View Single Post
 
Old 09-07-2012, 01:06 AM
mashley mashley is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Sep 2012
Posts: 3
mashley is on a distinguished road
Default

OK, there is more. Even though the sum if of numbers with only two decimal places, the sum itself is 8805.13000000001 !!!

So the only way I can get a correct result is by using TRUNC(SUM(G2:G261),2).

Weird, as I have several worksheets all very similar, but only this one produces this odd result.

Thanks Bill!!!
Reply With Quote