What do I call a blank cell?

N

Nancy

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?
 
K

Kassie

Hi Nancy

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

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)
 
Top