Forum Discussion
IF FORMULA ONLY WORKS ABOVE CERTAIN VALUE
I am new to this and have an if formula which only works if the value of a cell is over £10,000 or if a certain cell is 0. I've attached images below. Can anyone help? ...
Since you have currency amounts with 2 decimal places, you should round to 2 decimal places in the comparison:
=IF(ROUND(G37, 2)=ROUND(G47, 2), "Balanced", "Not Balanced")
or
=IF(ROUND(G37-G47, 2)=0, "Balanced", "Not Balanced")