View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kassie
 
Posts: n/a
Default 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?