Hi Chuck,

Does B7 contains a formula that may give results from an error or "" or
negative values ?
Does B7 shall contain type-in values ?
--
*****
birds of the same feather flock together..



"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