IF function showing False when True

[cmwilliams_]

IF function shown in top bar is showing as False (20+77)=97 should show true answer. Unsure why, any help would be appreciated.

20 and 77 are taken from another cell which is a =sum function to total up, was unsure if this had anything to do with it?

Any help appreciated, thanks.

[#2]

@cmwilliams_ 

It would be worth checking whether V5+W5-O5 is zero.  Checks like this work with whole numbers but decimal numbers will introduce small rounding errors.  If there is such error, a suitable test might be

= ABS(V5+W5-O5)<0.0001

[#3]

@Peter Bartholomew 

Hi Peter,

Just put that in there as a check, its coming back as TRUE.

Managed to figure out the rounding error was abit further down the line, so I've added a round function to the O5 to get rid of that and its now working!

Thanks for you help.