Forum Discussion
KevinHj
Nov 22, 2020Copper Contributor
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...
Riny_van_Eekelen
Nov 22, 2020Platinum Contributor
KevinHj Check out this link. And you can Google for more explanations of the issue.
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