| 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? |
| 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 | |||
Threaded Mode
