View Single Post
 
Old 05-28-2015, 11:41 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Actually Excel is adding correctly.

You are adding the numbers Excel is displaying, which happen to result from two cells that Excel is rounding up for display purposes, and comparing that to what Excel is getting, by using the real numbers and happens to round down for display purposes.

If you take your column "I" and adjust the formatting to show 6 decimal places, you will see what Excel is really working with and what the real results are.
Reply With Quote