If Formula returns true statement if cell is blank

[lhaitken]

Hi guys. Got a problem with an If formula.

in cell B11 i've got number of hours worked. and then in p11 i've got a formula that i want to return a certain set of data. Something like this.

=If(B11=0,"RESET DAY","")

this works fine but if the cell is blank then it still returns "RESET DAY". Any help would be great. Thanks.
-Larry

 

[Aladin Akyurek]

Hi guys. Got a problem with an If formula.

in cell B11 i've got number of hours worked. and then in p11 i've got a formula that i want to return a certain set of data. Something like this.

=If(B11=0,"RESET DAY","")

this works fine but if the cell is blank then it still returns "RESET DAY". Any help would be great. Thanks.
-Larry

If you want to return "RESET DAY" whenever B11 is a number, including a zero, try:

=IF(ISNUMBER(B11),"RESET DAY","")

Is this what you intend?

 

[mrhopko]

you could use ISBLANK()
something like
=IF(AND(B11=0,NOT(ISBLANK(B11))),"RESET DAY","")

Mrhopko

 

[lhaitken]

Hey Mrhopko that's working great. Thanks man.

 

[Aladin Akyurek]

Hey Mrhopko that's working great. Thanks man.

Does this mean that you want "RESET DAY" if only if there is a real zero in B11? If so,

=IF((A2<>"")*(A2=0),"RESET DAY","")