Forum Discussion

KevinHj's avatar
KevinHj
Copper Contributor
Nov 22, 2020

Issue with Equation Evaluating Incorrectly When Adding Fifth Term

I am currently working on an equation in my excel sheet where I am adding a series of values based on if statements that check if a cell is blank or not. I currently have 4 of the 8 if statements inp...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 22, 2020

KevinHj Check out this link. And you can Google for more explanations of the issue.

https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/ 

In other words, Excel may give seemingly incorrect answers. Your "incorrect" number is still zero up to 15 decimals. Wrap the formula in a ROUND function. For example:

=ROUND(<your formula>,14)

and the answer will be 0.00+00E

Resources