resolve undefined in running totals when data not input
 

Thanks in advance, any help is appreciated.

I am working on an excel spreadsheet that is a table with calculated running
totals of certain data etc. Say there are going to be responses for each
month of the year but having only completed the 3rd month, the calculations
for the other months show up as undefined because it is attempting to divide
by zero due to no data. I need teh running total to continue adding on when
new data is entered but i am not sure how to go about eliminating the
undefined (#Divo/0!) until data has been input so that the other months will
total correctly. This probably sounds extremely simple to some of you out
there but i am stumped. ANY help is appreciate =) thank you

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total / Average
8 8 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!
8 16 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!



Aso

resolve undefined in running totals when data not input
 

Ack sorry that wrapped around.. let me make an adjustment...

Jan Feb Mar Apr May ... Total /
Average
8 8 #Divo/0! #Divo/0! #Divo/0!
Running ToT: 8 16 #Divo/0! #Divo/0! #Divo/0!... #Divo/0!




"Aso" wrote:

Thanks in advance, any help is appreciated.

I am working on an excel spreadsheet that is a table with calculated running
totals of certain data etc. Say there are going to be responses for each
month of the year but having only completed the 3rd month, the calculations
for the other months show up as undefined because it is attempting to divide
by zero due to no data. I need teh running total to continue adding on when
new data is entered but i am not sure how to go about eliminating the
undefined (#Divo/0!) until data has been input so that the other months will
total correctly. This probably sounds extremely simple to some of you out
there but i am stumped. ANY help is appreciate =) thank you

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total / Average
8 8 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!
8 16 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!



Aso

resolve undefined in running totals when data not input
 

The usual practice is to trap for the lack of data and return "" instead of
the error.

Example =IF(A1="","",B1/A1)

You could also use the ISERROR in earlier versions or IFERROR in 2007
function but I do not recommend that because it will mask all errors which
may not be desirable.


Gord Dibben MS Excel MVP

On Tue, 7 Apr 2009 08:45:02 -0700, Aso
wrote:

Thanks in advance, any help is appreciated.

I am working on an excel spreadsheet that is a table with calculated running
totals of certain data etc. Say there are going to be responses for each
month of the year but having only completed the 3rd month, the calculations
for the other months show up as undefined because it is attempting to divide
by zero due to no data. I need teh running total to continue adding on when
new data is entered but i am not sure how to go about eliminating the
undefined (#Divo/0!) until data has been input so that the other months will
total correctly. This probably sounds extremely simple to some of you out
there but i am stumped. ANY help is appreciate =) thank you

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total / Average
8 8 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!
8 16 #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0! #Divo/0!



Aso