DIV/0 vs 0.00

D

Deborah

I am making a template where there is a number table
followed by a Percentage distribution table.
Another person will fill in the values for the table and
the percentage one will automatically get filled in.
For the totals in the Percentage table I expected to see
#DIV/0 as there are no numbers yet and the cells are
formatted for number with 1 decimal position.
However, only 2 columns (out of 10) are instead displayed
0.0?
The formatting of all cells is identical and the original
formula was copied from the first column to the others.
Therefore, I can not find where the difference lies.
Can someone clue me in?

Many thanks.
 
I

IC

Deborah said:
I am making a template where there is a number table
followed by a Percentage distribution table.
Another person will fill in the values for the table and
the percentage one will automatically get filled in.
For the totals in the Percentage table I expected to see
#DIV/0 as there are no numbers yet and the cells are
formatted for number with 1 decimal position.
However, only 2 columns (out of 10) are instead displayed
0.0?
The formatting of all cells is identical and the original
formula was copied from the first column to the others.
Therefore, I can not find where the difference lies.
Can someone clue me in?
Click to expand...

When you copy a formula from one cell to another, the references in the
formula normally change unless they are specified as absolute values.

eg if you copy =A1+B1 from C1 to D1, the result is =B1+C1. Could this be the
issue?

To make a column or row reference absolute, prefix it with $. eg $A1 will
retain A but the 1 will change to 2 if you copy the formula down a row.

Hope this helps

Ian
 
Top