Paste as values changes the outcome of formula...

[Blackeye]

Hello everyone,

I am facing an issue with copy/pasting a formula as values which results in my pasted value being incorrect according to me.

This is what I did:

value 503 in A1.
value 1.14 in B1.
value 573.42 in C1 (outcome from sum A1 * B1)
Value 0.42 in D1 (outcome from sum A1 * B1 - C1) this because I only wanted to have the decimals
Value 0.42 in E1 (copy/pasting as values D1 to E1)

The value in cell E1 is 0.42000000000, which is according to me correct. However, for some reason in the formula bar a value for cell E1 is shown as 0.419999999999959...

I tried to understand how excel comes with this value, which I believe is incorrect as all I entered was a max of 2 decimals which should result in an output of max 2 decimals.

Does someone else has the same experience or does someone knows how to solve this issue?

Ps. this formula worked for me for already a couple of years but suddenly it is calculating incorrectly, which let me believe it might be something with my excel settings instead, but I don't know what?

Many thanks.

Kind Regards,

Blackeye

 

[Andrew Poulsom]

Welcome to MrExcel.

Have a read of this:

https://support.microsoft.com/en-us/kb/78113

 

[Blackeye]

Thank you Andrew for this link.

Method 1: The round function indeed solved my problem.

Blackeye