if =0 ""

[billy_bags]

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))

In article <B5FAC831-EA6D-4F9A-8305-D1FF45AD39E7@microsoft.com>,
"billy_bags" <billybags@discussions.microsoft.com> wrote:

> 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