And I misread your requirements...

=if(b7="",0,if(b7=0,4,"whatdoyouwanthere?"))

Chuck_in_Mo wrote:

I put a 0 between the quotes, and am still getting a value of 4 in the cell
as if excel is seeing a blank cell as a value = zero....

"Dave Peterson" wrote:

Put this formula in Z4:
=if(b7=0,4,"whatdoyouwanthere?")

(Excel will treat an empty cell as 0.)

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?

--

Dave Peterson


--

Dave Peterson