#DIV/0! Question

[TKM]

I am migrating to Office 2007 and I am receiving #DIV/0!
in all of my cells on my workbooks. Can anyone help me find a soloction to
this problem. I am able to enter numbers but the results are the same #DIV/0!


thank you

 

[John C]

The formula(s) would be good to know.

 

[ShaneDevenshire]

Hi,

"all of my cells"? cells that are empty, cells that contain text, cells
with single numbers and formulas, all return DIV/0?

This error usually only occurs with calculations, (formulas or functions).
If that is what you mean, do you really mean all - is the formula
=sum(a1:a10) returning DIV/0 when A1:A10 are blank?

If it really is - some formulas, we need to know the formula and maybe some
sample data, that is used by that formula.

 

[TKM]

Yes that would help sorry. Here are some basics.

=E2/E5
=Sheet1!A5
=Sheet1!AH13
=1-(O3*3+O6*3)/(O2-O5)

 

[David Biddulph]

=E2/E5 will return #DIV/0! if E5 is zero or empty, so you need to have a
look to see what is in E5.
=E2/E5 will also return #DIV/0! if E2 contains #DIV/0!, so you may also need
to have a look to see what is in E2.
=Sheet1!A5 will return #DIV/0! if Sheet1!A5 contains #DIV/0!, so you need to
have a look to see what is in Sheet1!A5.
=Sheet1!AH13 will return #DIV/0! if Sheet1!AH13 contains #DIV/0!, so you
need to have a look to see what is in Sheet1!AH13.
=1-(O3*3+O6*3)/(O2-O5) will return #DIV/0! if O2-O5 is zero or those cells
are empty, so you need to have a look at what is in O2 and O5.
=1-(O3*3+O6*3)/(O2-O5) will also return #DIV/0! if either O3 or O6 contain
#DIV/0!, so you may also need to have a look at what is in O3 and O6.

 

[TKM]

Thank you for your hdlp! I was courious that =($C$124-C126)/$C$124 and all
other formuls had the same type of error when the sheet was opened. No values
were placed into the cells it only shows these when the application is
opened. Are you saying something must be in the cells before those errors
dissappear?

thanks for your help

 

[ShaneDevenshire]

Hi,

So its not really all cells, just ones containing formulas. If one formula
returns a DIV/0 error any other formulas which refer to it will also return
the error. Errors propogate in Excel.