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?