What does this excel formula mean?

Jaye - Nov 28, 2017 at 06:03 PM - Latest reply: ac3mark 8362 Posts Monday June 3, 2013Registration dateModeratorStatus December 14, 2017 Last seen
- Nov 29, 2017 at 04:09 PM
Hello,


Wondering if someone can assist and tell me what the following excel formula is doing:

=IF($C$68<=O2,IF(N12>$D$98,$D$98,N12),0)

Context: Forecasting

$C$68 - Cell is showing 1/4/2018 (Remediated Start Date)
O2 - Cell is showing SEP-18 (Forecast Month)
N12 - Cell is showing 15000 (from the previous forecast month)
$D$98 - Cell is showing 15000 (Remediated volume of 15000

Appreciate anyone who can assist :)


See more 

3 replies

Reply to this topic
ac3mark 8362 Posts Monday June 3, 2013Registration dateModeratorStatus December 14, 2017 Last seen - Nov 28, 2017 at 06:58 PM
0
Helpful
1
Is this homework?
Respond to ac3mark
ac3mark 8362 Posts Monday June 3, 2013Registration dateModeratorStatus December 14, 2017 Last seen - Updated by ac3mark on 29/11/17 at 04:10 PM
0
Helpful
It says, if C68 <= O2 is true, then check to see if N12>D98, if it is, then display D98, if not then display N12. If C68 is not <=O2, display a zero!



It's kind of fun to do the impossible! -Walter Elias Disney
Respond to ac3mark