The & operator is changing the subtraction operator (-)

[Susan_Oster]

In cell B9, I am using the formula     ="Dichloram = "&(B8-A8)

Cell B8 has the value 2.12

Cell A8 has the value of 2.03

Therefore (B8-A8) should be 0.09 and if I type =(G8-F8) into a cell it returns 0.09

However, the formula "Dichloram = "&(B8-A8) returns Dichloram = 0.09000000000000003

The same formula with different values other than 2.12 and 2.03 seems to work.

Microsoft® Excel® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 32-bit

Windows 11 on PC

[#2 · Accepted solution]

@Susan_Oster 

That's floating point error. You may use instead

="Dichloram = " & TEXT(B8-A8, "0.00")

or like

[#3]

Thank you! Today I learned about floating point errors!

[#4]

@Susan_Oster , you are welcome