Thanks!
Thats it..... The formula wasn't working unless I clicked in the blank cell
and hit the delete key, so, although it looked empty, it had something in it!

"David Biddulph" wrote:

In which case, if your cell looks blank but returns the 4, you've probably
got one or more spaces (or other invisible characters) in a text string in
B7. What does =LEN(B7) give you? If it doesn't return 0, go into B7 and
delete the spaces or whatever is there.
--
David Biddulph

"Chuck_in_Mo" wrote in message
...
Thanks again... still getting the 4 value though....

"Teethless mama" wrote:

Ignore my first reply
Here is the correction formula
=IF(B7="","",IF(B7=0,4))


"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?