formula based on percentages

[michelle]

this is driving me insane. I have a bunch of spreadsheets
with a list of numbers. these numbers are then
multiplied by 1.75%. Then I have another spreadsheet
that adds each number from each spreadsheet together.
Somewhere along the line it ends up being 1 cent
short!!!! Where is it going! In the final spreadsheet I
have a formula linking each cell from each other sheet to
get a number. if I then type the exact same numbers by
hand all the way down and add them up, they equal the
correct amount. the results of the formulas are showing
the same amounts but not adding properly!! WHY????

 

[Don Guillett]

The short answer is rounding. Apply rounding in your formulas to get what
you want.

 

[Frank Kabel]

In addition to Don's answer see:
http://www.cpearson.com/excel/rounding.htm