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
What am I doing wrong?