What do I call a blank cell?

[Guest]

My formula is IF(H27>0,H27,(M25+M26)*0.15). I want the test to include zero
in the true statement, but if I put >= it accepts blanks. How can I write
this?

 

[Guest]

=if(and(h27>=0,not(isblank(h27))),h27,(m25+m26)*0.15)

 

[Guest]

Hi Nancy

The following formula seems to do the trick
=IF(OR(AND(H27<>"",H27=0),H27>0),H27,(M25+M26)*0.15)
hth

 

[daddylonglegs]

If H27 cannot be negative

=IF(H27="",(M25+M26)*0.15,H27)

or if it can

=IF(OR(H27="",H27<0),(M25+M26)*0.15,H27)

 

[Guest]

AWESOME!!!! Thank you.

=if(and(h27>=0,not(isblank(h27))),h27,(m25+m26)*0.15)