Yes, you're right. Sorry about that. Brain's frozen!

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"David Biddulph" wrote:

You probably need to put Dave's formula the other way round:
=IF(ISBLANK(B10),0,IF(B10=0,4,"undefined"))
--
David Biddulph

"Chuck_in_Mo" wrote in message
...
I entered
=IF(B10=0,4,IF(ISBLANK(B10),0))
and it is still giving me a value of 4 when the cell in blank.....

"Dave F" wrote:

=IF(B7=0,4,IF(ISBLANK(B7),0))

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Chuck_in_Mo" wrote:

I am trying to get a cell to do this:

Look at cell B7, if B7 has a vlaue of greater than or equal to 0,
return a
value of 4 to cell Z4, if cell B7 is empty return a value of 0 to cell
Z4....

Can you help?