Solved

# Excell error #DIV/0

Posted on 2002-04-15

I have designed an excell worksheet with columns A thru K. My question refers to rows 10 thru 20 which have some simple calculations.

G10 has the formula: H10-F10

G11 thru 19 has the same formula (H11-F11, etc.)

J10 has the formula: F10/H10 (The result is a percentage)

J11 thru 19 has the same formula (F11/H11, etc.)

K10 has the formula: D10*J10-E10

K11 thru 19 has the same formula (D11*J11-E11, etc.)

I10 has the formula: D10-H10

I11 thru I19 has the same formula (D11-H11, etc.)

Row 20 contains totals for each column.

Example: Cell G20 Formula: G10:G19

My problem is trying to get a running total in Cell K20. Formula: K11:K19.

Since the individual cells, K10 thru K19, have the formula D*J-E, and values have not been entered for all of those cells; I get an error: #DIV/0 in Cell K10 thru K19.

The problem is that Cell K20 will not give me a total unless all cells, K10 thru K19, have a value.

Example: D10=100,000, J10=85%, E10=50,000, then K10=35,000. (D10*J10-E10)

Since values have not been filled in for the other rows, K11 thru K19, I get the error #DIV/0 in Cell K20.

Is there any way to get rid of that error and show a value of Zero in cells K10 thru K19 until a value has been inputed in the other cells so that I will have a running total in Cell K20?