Oct 31 2020 08:25 AM - edited Oct 31 2020 08:27 AM
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.
Oct 31 2020 09:24 AM
SolutionExcel'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.
Oct 31 2020 09:24 AM
SolutionExcel'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.