Sum of Excel result Error

October 26, 2011 at 19:30:04
Specs: Windows XP
A1: -51.2, A2: -51.0. If I sum A1 + A2, the result is -0.200000000000003 instead of -0.200000000000000. Where is 0.000000000000003 come from?

See More: Sum of Excel result Error

Report •

October 26, 2011 at 21:28:05
Before we even discuss the 0.000000000000003 how can 2 numbers that are negative 51 or lower sum to a number that is greater than negative 1?

Doesn't the sum have to be less than negative 102?

Are you sure you posted what you wanted to post?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question