Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel =0/div
I have seven cells that I am trying to average the total in the eighth cell.
The worksheet is will not necessarely have an amount in each of the seven cells I am trying to average therefore I get a =0/div in the total cell unless there is at least one cell with content. How can I clean up the worksheet so the =0/div does not appear when there is no activity in any of the seven cells. This is the formula I have tried but it will not work. =IF(P3=0),"",(AVERAGE(D3,F3,H3,J3,K3,L3,N3) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |