Thread: Copy/Paste values rounding problem.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sinner Sinner is offline
external usenet poster
  
Posts: 142
Default Copy/Paste values rounding problem.
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?

Reply With QuoteReply With Quote