I had inadvertently changed your G5 formula, so the results for the following rows in G, changed. So removing the conditional formatting wasn't the problem Sooo I haven't got a clue, just worry about Excel's math.

Would love to see you test this in USD.