I feel so stupid! I guess when you put in a ten hour day this is what I get.
I relooked at the formulas, and what I was doing was coping the formul from
the first cell to the other two, well the cell referance was changeing....
duh!

Such a rookie error... I feel bad that I wasted your an everyone elses
time...

Thanks everyone, I feel much better that I now know it was my error, and a
dumb one at that, and I can trust my spreadsheets...

Thanks again
Jacqueline

"Meebers" wrote:

I think the only way we can help you is for you to give us some sample
numbers. The result you get and the result you expect. Most likely between
the real number and the number being displayed? Looking forward to your
sample.


"Jacqueline" wrote in message
...
In one case the numbers were off by 4%, a differance between 6% and 10%.
When
I hand calculated the total, and used that number to obtain my perctage
the
correct number was displayed.

My fear, is that with the mucking around they did with the app, I have
something that is turned on or not turned on that is effecting the way my
numbers are calculating. I do not like the feeling that I can no longer
trust
my spreadsheet, and don't have the time to run all the totals by hand.

I was wondering if because I was running the formula off another formula
that it was somehow effecting my results. I have formated all the numbers
the
same.

I have used Excel for a long time, so rest asured I have checked
everything
I know to check believing the problem is with me, and not the app.
However,
with the changes they made in 2007, I am unsure of my self.

If you have a suggestion that can help I woul love to hear it.
J

"JoeU2004" wrote:

"Jacqueline" wrote:
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.

Rest assured that it is almost certainly not an error in Excel 2007,
unless
you can demonstrate that Excel 2003 has different results with exactly
the
same workbook and calculation options.

Without seeing the numbers and at least the formulas, we can only offer
educated guesses. If you truly would like some help, you will need to
provide the obviously missing information.

My guess: you have "Precision as displayed" set, or when you add the
numbers, you incorporate some form of rounding, so that the sum of
G16:I16
that you compute separately ("add the numbers") is not the same as
SUM(G16:I16).

However, I do not know what you mean by "off by a couple of numbers".
What
is "a couple of numbers"? Why don't you say exactly how far off the
percentages or the sum of the percentages is?


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

"Jacqueline" wrote in message
...
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