Forum Discussion
Solved
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...
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.
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.