Forum Discussion
a*b≠a*b error in excel
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.
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.
1 Reply
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.