"Jacqueline" wrote:
Is this something I need to check for in 2007? If so, where do I find it;
I looked in Excel options but did not find anything?

I hope Bob or someone else can answer the Excel 2007 question. I cannot.

In Excel 2003, click on Tools Options Calculation. Determine whether or
not "Precision as displayed" is checkmarked.

Caveat: D O N O T experiment with the PAD option unless you first make
a back-up copy of the workbook. Setting PAD can have irreversible effects,
notably on a constant entered into a cell that has a format other than
General.


----- original message -----

"Jacqueline" wrote in message
...
Sorry Bob, I muddied the water I guess, I am actually using 2007 and
lamenting that I did not have these problems in 2003...

Is this something I need to check for in 2007? If so, where do I find it;
I
looked in Excel options but did not find anything?
Thanks
Jacqueline

"BobT" wrote:

Check to see if your option for Calculation is set to "Precision as
displayed". In 2003 it's off by default.

"Jacqueline" wrote:

I am running some simple percentage formulas, but the rounding errors
are
driving me nuts..

If I add the numbers and use that to find my percentage it gets closer
to
the 100% total each should have. However, if I use a formula such as:

=G16/(SUM(G16:I16))
The rounding can be off by a couple of numbers. Cells G16 and I16 are
total
cells, for a column of numbers.
=SUM(G7:G15)
I have made sure the analysis tool pack is installed, and yet my
numbers
continue to be off. I do not remember running into this problem in
2003. Is
there a fix, is anyone else having these problems?

Thanks,
Jacqueline