Forum Discussion
Susan_Oster
Nov 20, 2023Copper Contributor
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...
- Nov 20, 2023
That's floating point error. You may use instead
="Dichloram = " & TEXT(B8-A8, "0.00")
or like
SergeiBaklan
MVP
That's floating point error. You may use instead
="Dichloram = " & TEXT(B8-A8, "0.00")
or like
Susan_Oster
Nov 20, 2023Copper Contributor
Thank you! Today I learned about floating point errors!
- SergeiBaklanNov 21, 2023MVP
Susan_Oster , you are welcome