Paste special - Values

  • Thread starter Thread starter Fritz
  • Start date Start date
F

Fritz

The result of a simple formula should be a whole number.
However, when I used Copy, Paste Special, Values it
returns decimal values that are slightly above or below
the expected whole number. For example, when A1 contains
the value 49.931, copying the value from the formula (A1-
49)*1000 yields 930.999999999997. Any explanation would
be appreciated.
 
Its because 10 divided by 3 for instance is 3.333333 etc. If you format it
to 2 decimal places it displays as 3.33, but the actual value is still
3.333333333 to I believe in Excel 15 decimal places, though I may be wrong
there.
If you wrap your formulas with the ROUND function,
=ROUND(Your Formula,2)
You'll get a true 2 decimal result, ie
=ROUND(10/3,2) will return 3.33
Regards,
Alan.
 
Back
Top