Sorry, I don't know if my original post showed up.

I'm having a problem with a IF function which is showing up a "check" result when it shouldn't.

The formula is =IF(A3-SUM(B3:C3)=0,"-","check")

But when I put 17.89 in column A, £16.90 in column B and £0.99 in column C is gives the result "check" instead of "-"

It works ok with other numbers so what am I doing wrong??