What does this excel formula mean?

Closed
Jaye - Nov 28, 2017 at 06:03 PM
 Blocked Profile - 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 :)


2 responses

Blocked Profile
Nov 28, 2017 at 06:58 PM
Is this homework?
0
Work related :)
0
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
0