Copy/Paste values rounding problem.
Try
=ROUNDUP(B1-C1,0)
Mike
"Sinner" wrote:
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?
|