ExcelBanter - Copy/Paste values rounding problem.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy/Paste values rounding problem. (https://www.excelbanter.com/excel-programming/408235-copy-paste-values-rounding-problem.html)

Sinner

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?

Mike H

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?

All times are GMT +1. The time now is 12:26 PM.