If I undertsna dyour question correctly, the B7 field will either be blank
(as in this case) or have a value between 0 and 4.... The formula I am
looking for will "look" at that B7 cell and either return with a blank or
zero (in the case of a blank B7 cell) or return with a value of 4 if a value
of 0 - 4 is entered into B7....

Hope this wasn't too confusing...

Could it be some type of formatting issue?

"driller" wrote:

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