What do I call a blank cell?
Hi Nancy
The following formula seems to do the trick
=IF(OR(AND(H27<"",H27=0),H270),H27,(M25+M26)*0.1 5)
hth
"Nancy" wrote:
My formula is IF(H270,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?
|