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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy, Paste special, Values 1
Paste Special Values 2
I can't copy and paste equations 0
Paste Special Formula Multiply feature doesn't work anymore 2
Macro to copy & paste-special-values data to selected worksheets 1
copy and paste the cell with formula ="1" 3
Copy and paste special 2
help: paste special with an operation (add, multiply,...) convertseverything to values, pasted formu 1

Back
Top