a*b≠a*b error in excel

[Banu1337]

Hello,

I'm currently working in a very large excel spreadsheet that contains many tiny numbers. As you can see in the picture (I'm using an if statement which is 1 if they are equal and 0 if not) it says that AHP31=AHO31 and AHP32=AHO32 but apparently AHO31*AHO32=AHP31*AHP32 is false. The difference is around 1.3*10^-28. I haven't formatted any cells manually so this is very confusing.

[#2 · Accepted solution]

@Banu1337 

Excel's uses IEEE 754 - see Floating-point arithmetic may give inaccurate results in Excel 

In short, you cannot expect results to be exactly correct, so you should round the result of formulas.