Your formula runs without any error, but the value it returns is not the one you expected. This is the most misleading kind of problem, because nothing looks broken until you check the result.
Choose one of the causes below, then click Run to see how the formula works on the grid and why the result goes wrong.