Originally Posted By: gbeer
I'll guess that the value causing trouble is tossing off an infinite repeating result. like 3/2.


No, this spreadsheet is nothing more than a series of two-decimal numbers, manually keyed in, and totaled with the total at the top rather than the customary bottom so I could freeze the top row while scrolling.

There are no repeating decimals, and no divisions. Just a column of numbers formatted as currency. Why this generates a rounding error is what puzzles me.

tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"