Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Faulty Averaging Formula
In the averaged cells, AB31...AN31, it is possible they may all b blank. Using the AVERAGE function returns the error #DIV/0!. Is ther a way to have the below formula, located in cell Z31, enter a blank? This formula still enters ther error. Or is there another construc for the formula? =IF((AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31)=" #DIV/0!"),"",AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31,AN31 ) -- Phil H ----------------------------------------------------------------------- Phil H.'s Profile: http://www.hightechtalks.com/m22 View this thread: http://www.hightechtalks.com/t228156 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
site faulty? | Excel Discussion (Misc queries) | |||
Averaging with a formula | Excel Discussion (Misc queries) | |||
Faulty Page Tabs | Excel Discussion (Misc queries) | |||
faulty PasteSpecial line?? | Excel Programming | |||
Averaging formula help, please. | Excel Programming |