Result = to 0 says false
May have overlooked the obvious first thing to check!
Are you sure the zero is a numeric 0 and not a TEXT 0?
=IF(Y4="0","Yes","No")
If that formula returns Yes then the 0 in Y4 is TEXT.
Biff
"Biff" wrote in message
...
The result of Y4 might not be exactly 0 but Excel "fudges" it to be 0. Try
this:
Format cell Y4 as NUMBER and set it to 15 decimal places. Do you get
exactly 0.000000000000000 or do you get something like this:
0.000000000721000
Biff
"Becky" wrote in message
...
I am pulling my hair out at this point and need some help.
I have a worksheet with many cells and calculations.
I have calculations performing on results of a calculation. In then end
of
all of this I have a If statement that says IF(Y4=0,"Yes","No")
In the function argument box it says that Y4 is false and the result
inthat
cell is 0.
So it is telling me that 0 is not equal to 0.
I don't get it. This was a sheet I got from an end user and at first I
thought it was her formatting so I copied the contents and pasted the
values
and did the calculations my self. Still same result. Then I started the
whole sheet over from scratch and still same result.
If this is not clear I can post the cells and their contents. Just let me
know what you need.
|