Hi Mo,

from the original post..
if B7 has a vlaue of greater than or equal to 0, return a value of 4 to cell Z4,
this means IF B7=0 THEN 4
if cell B7 is empty return a value of 0 to cell Z4...
this means IF B7="" THEN 0
=if(b7="",0,4) -----this may be the case


then you mentioned a while ago
and either return with a blank or zero (in the case of a blank B7 cell)
this means IF B7="" THEN RETURN "BLANK" OR 0 !
or return with a value of 4 if a value of 0 - 4 is entered into B7.... "
this means IF AND(B7=0,B7<=4) THEN 4

=IF (B7="","",IF(AND(B7=0,B7<=4),4,"don't exceed 4"))

Are these something you can work with?

regards

regards


--
*****
birds of the same feather flock together..



"Chuck_in_Mo" wrote:

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