Excel 2003
Statement in cell E316
=if(D316<0,1,0) - This works fine

I need to change this to include 0 (zero) as true
Changed to =IF(D316=0,1,0)
This does NOT work.

Tried ( on different computer )
=if(D316="",0,1)
This would also be acceptable, since I will have validation on cell D316.
It worked on that computer, NOT on mine

What am I missing.
I use that same statement ( the last one ) elsewhere on my sheets and it works
fine. When copied to E316, it doesn't work.

Help
--
John F. Scholten

Have a look at the ISBLANK() function, I think that might be what you're
looking for.

Carlos
"John F" wrote in message
...
Excel 2003
Statement in cell E316
=if(D316<0,1,0) - This works fine

I need to change this to include 0 (zero) as true
Changed to =IF(D316=0,1,0)
This does NOT work.

Tried ( on different computer )
=if(D316="",0,1)
This would also be acceptable, since I will have validation on cell
D316.
It worked on that computer, NOT on mine

What am I missing.
I use that same statement ( the last one ) elsewhere on my sheets and it
works
fine. When copied to E316, it doesn't work.

Help
--
John F. Scholten