Share your formula.

And what's in B7.

Maybe...

=if(trim(b7)="",0,if(b7=0,4,0))

(Don't use "0" if you want a real number--not text.)

Chuck_in_Mo wrote:

Dave,

I put a zero between the quotes, to reflect the balnk field... Still getting
a 4.....

"Dave Peterson" wrote:

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


--

Dave Peterson