Forum Discussion
The & operator is changing the subtraction operator (-)
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 i...
That's floating point error. You may use instead
="Dichloram = " & TEXT(B8-A8, "0.00")or like
Thank you! Today I learned about floating point errors!
Susan_Oster , you are welcome
