What does this excel formula mean?

Jaye - Nov 28, 2017 at 06:03 PM
 Blocked Profile - Nov 29, 2017 at 04:09 PM

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


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 replies

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