=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