Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display 0 if it is the end result for a formula
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display 0 if it is the end result for a formula
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display 0 if it is the end result for a formula
=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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display 0 if it is the end result for a formula
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" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display 0 if it is the end result for a formula
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" wrote in message ... 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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't get the formula result to display on my spreadsheet. | New Users to Excel | |||
Display result in same cell as formula | Excel Discussion (Misc queries) | |||
Display result of formula in header? | Excel Discussion (Misc queries) | |||
Formula is entered but will not display result | Excel Worksheet Functions | |||
How do I display the RESULT of a formula | New Users to Excel |