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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Faulty Averaging Formula
Phil,
Try ... =IF((ISERROR(AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31 ,AN31))),"",AVERAGE(AB31,AD31,AF31,AH31,AJ31,AL31, AN31)) HTH "Phil H." wrote: In the averaged cells, AB31...AN31, it is possible they may all be blank. Using the AVERAGE function returns the error #DIV/0!. Is there a way to have the below formula, located in cell Z31, enter a blank? This formula still enters ther error. Or is there another construct 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/m229 View this thread: http://www.hightechtalks.com/t2281562 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Faulty Averaging Formula
Hi Toppers, That works! Thanks for the help. Phi -- Phil H ----------------------------------------------------------------------- Phil H.'s Profile: http://www.hightechtalks.com/m22 View this thread: http://www.hightechtalks.com/t228156 |
Reply |
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 |