View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nancy
 
Posts: n/a
Default What do I call a blank cell?

AWESOME!!!! Thank you.

"bpeltzer" wrote:

=if(and(h27=0,not(isblank(h27))),h27,(m25+m26)*0. 15)

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