numbers not adding up correctly in spreadsheet
 

Why doesn't excel add up the amounts correctly when it's the sum of multiple
formulas.

On Fri, 11 Mar 2005 16:13:02 -0800, "tyvball"
wrote:

Why doesn't excel add up the amounts correctly when it's the sum of multiple
formulas.

Either you are misinterpreting what you are seeing, or you are running into the
limitations of the IEEE (Institute of Electrical and Electronic Engineers)
Double Precision Floating Point number format which Excel, and most other
spreadsheet programs, uses as the most accurate representation of a number.
You can read more about this at www.cpearson.com/excel/rounding.htm


--ron