If the figures are calculated there may be rounding issues (for
example, 1.75 could actually be 1.748). Excel is using the actual cell
values and not the displayed values when comparing figures.

Try rounding your results to 2 places where you are calculating figures.