Thread: if =0 ""
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ramana
 
Posts: n/a
Default if =0 ""
Hi bill,

Just try this.

K7=IF(OR(B70,C70,D70,E70,F70),SUM(B7:F7)," ").

The formula worked for me.

Regards

Ramana

Reply With QuoteReply With Quote