I have a problem, I'm trying to run the following formula
(=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
which is to find out the average of a weekly call survey but some cells are
blank due to the fact that there are no value inputed because no calls where
made on specific day and the end result turns up an error (#DIV/O!). How can
I make it so if the cells are blank, the end result will turn to display zero?

Try

=IF((D7+G7+J7+M7+P7+S7+V7)=0,0,
((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Ruben061479" <(E-Mail Removed)> wrote in message
news:FBA302DD-9C0A-4E7B-A5CD-(E-Mail Removed)...
>I have a problem, I'm trying to run the following formula
> (=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
> which is to find out the average of a weekly call survey but some cells
> are
> blank due to the fact that there are no value inputed because no calls
> where
> made on specific day and the end result turns up an error (#DIV/O!). How
> can
> I make it so if the cells are blank, the end result will turn to display
> zero?

=IF(D7+G7+J7+M7+P7+S7+V7=0,0,((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))

"Ruben061479" wrote:

> I have a problem, I'm trying to run the following formula
> (=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
> which is to find out the average of a weekly call survey but some cells are
> blank due to the fact that there are no value inputed because no calls where
> made on specific day and the end result turns up an error (#DIV/O!). How can
> I make it so if the cells are blank, the end result will turn to display zero?

Thank You very much this worked perfectly, You don't know how much I
appreciate your help!!!! Thank You!!!!!!!

"Chip Pearson" wrote:

> Try
>
> =IF((D7+G7+J7+M7+P7+S7+V7)=0,0,
> ((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting
> www.cpearson.com
> (email on the web site)
>
>
> "Ruben061479" <(E-Mail Removed)> wrote in message
> news:FBA302DD-9C0A-4E7B-A5CD-(E-Mail Removed)...
> >I have a problem, I'm trying to run the following formula
> > (=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
> > which is to find out the average of a weekly call survey but some cells
> > are
> > blank due to the fact that there are no value inputed because no calls
> > where
> > made on specific day and the end result turns up an error (#DIV/O!). How
> > can
> > I make it so if the cells are blank, the end result will turn to display
> > zero?
>

Also there is no need for all those brackets.
=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))
is the same as
=(D7*E7+G7*H7+J7*K7+M7*N7+P7*Q7+S7*T7+V7*W7)

HTH
Martin


"Ruben061479" <(E-Mail Removed)> wrote in message
news:4705B307-EF7C-4CB3-91E6-(E-Mail Removed)...
> Thank You very much this worked perfectly, You don't know how much I
> appreciate your help!!!! Thank You!!!!!!!
>
> "Chip Pearson" wrote:
>
>> Try
>>
>> =IF((D7+G7+J7+M7+P7+S7+V7)=0,0,
>> ((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting
>> www.cpearson.com
>> (email on the web site)
>>
>>
>> "Ruben061479" <(E-Mail Removed)> wrote in message
>> news:FBA302DD-9C0A-4E7B-A5CD-(E-Mail Removed)...
>> >I have a problem, I'm trying to run the following formula
>> > (=((D7*E7)+(G7*H7)+(J7*K7)+(M7*N7)+(P7*Q7)+(S7*T7)+(V7*W7))/(D7+G7+J7+M7+P7+S7+V7))
>> > which is to find out the average of a weekly call survey but some cells
>> > are
>> > blank due to the fact that there are no value inputed because no calls
>> > where
>> > made on specific day and the end result turns up an error (#DIV/O!).
>> > How
>> > can
>> > I make it so if the cells are blank, the end result will turn to
>> > display
>> > zero?
>>