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?