In cell B9, I am using the formula ="Dichloram = "&(B8-A8)Cell B8 has the value 2.12Cell 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.09However, 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

Susan_Oster That's floating point error. You may use instead ="Dichloram = " & TEXT(B8-A8, "0.00") or like

Forum Discussion

Copper Contributor

Nov 20, 2023

Solved

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