What's wrong with this Excel formula?

Factual Questions
1

=if(C33=0,=if(D33<=0,0,1),E33/C33)

If C33 = 0 then I have to worry about #div/0 error. So, if C33 = 0, then

If D33 <= 0 then I want the result to be 0

If D33 > 0 then I want the result to be 1

E33 is the variance.

If C33 <> 0 then divide E33 by C33 to get the percent variance.
It should be equivalent to this:

If C33 = 0 then
(if D33 <=0 then 0
else 1)
else E33/C33

What am I doing wrong?
Roddy

2

Try =IF(C33=0,IF(D33<=0,0,1),E33/C33)

3

:smack:

Don’t need the 2nd = sign because it already knows it’s a formula.

:smack::smack::smack:

Thanks, PP for not calling me an idiot (which I probably deserve)
Roddy