Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
eliminating the 0 in DIV/0
I am a very basic XL user, but I work with spread sheets using the simple AVG
formula. Is there any way to by pass the "0" in DIV/0? in other words, I am using 4 columns of numbers that were each averaged. There is another column with the average of the 4 separate columns, but I get the "DIV/0" unless all 4 of the other colums have a base larger than "0". In other words do I have to wait until all 4 coulms are completed before I can determine the on going average, or is there a formula or way to get the averages of the columns that do not have a zero base and not have to wait until all 4 colums have a base larger than zero? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with dividing and using ISERROR for Div/0! | Excel Worksheet Functions | |||
how to remove #DIV/0! | Excel Worksheet Functions | |||
How do you write an if statement that replaces #DIV/0! with 0 | Excel Discussion (Misc queries) | |||
How to replace div/0 with a zero | Excel Discussion (Misc queries) | |||
How to hide #DIV/0! in cells waiting for input? | Excel Discussion (Misc queries) |