if =0 ""

[Guest]

in K7 I have the sum of b7:F7
if sum b7:f7 = 0.00 then i want to leave k7 blank; but if there is data in
b7:f7 I want the total
my formula is
=if(b7:f7=0,"",sum(b7:f7))
With figures in this range the current response is #VALUE

I know it must be simple and I thought I had followed the logical tests etc
that appear to prompt you
but.....
appreciate your clarification
Bill

 

[ramana]

Hi bill,

Just try this.

K7=IF(OR(B7>0,C7>0,D7>0,E7>0,F7>0),SUM(B7:F7)," ").

The formula worked for me.

Regards

Ramana

 

[JE McGimpsey]

One way:

=IF(SUM(B7:F7)=0,"",SUM(B7:F7))