Zero as a value
That was it. I had =IF(E8="0","0",IF(E8<0,E8+1,IF(E81,E8-1,E8)))
in F8. When I removed the quotations and changed the formula to
=IF(E8="0",0,IF(E8<0,E8+1,IF(E81,E8-1,E8))) everything ran smoothly.
Thanks for your help.
"CLR" wrote:
It could be that your formula is actually returning a TEXT character rather
than a numerical ZERO.
Try a test by re-typing a simple formula in F8 that will return zero, like
=a1 if A1 is empty.
hth
Vaya con Dios,
Chuck, CABGx3
"StephanieH" wrote:
In F8, I have a formula that results in the value "0" (zero). I have the
cell formatted as a number.
In H8, I have the following formula:
=IF(F8=2,"1",IF(F8=1,"2", IF(F8=0,"3",IF(F8=-1,"4",IF(F8<-2,"5","N/A")))))
Given that my result in F8 is 0, I would expect the expression to evaluate
to 3. However, it returns 1.
When I type over the result of the formula and enter 0 directly into the
cell, it does returns the correct answer of 3.
In each of my tests, when F8 results in anything other than 0, H8 seems to
work fine.
How do I get Excel to recognize the value 0 for F8 in cell H8?
|