Copy/Paste values rounding problem.

S

Sinner

Hi,

I have a value in columnB say 3042.
In columnC, I am multiplying it with 20/100 say =3042*20/100 = 608.4
Result in columnD is 3042-608=2434.

When I copy & paste values in columnE, it yeilds 2433.6 but I want
2434.

Any ideas why?
 

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

How to calculate: sumproduct / db?? 8
how to append and remove dups 1
Stuck try to figure out a formula 1
DATE REVIEW BY COLUMN 1
Index/match across multiple columns? 19
Update worksheets 1
Conditional Copy and paste 2
Fill all the cells of a pivot table 2

Top