Excel if statement returns false, when it should be true

[Nando1988]

I have a formula that uses an if statement to compare if 2 columns are equal.
I am getting true for some and false for others, and after I make both cells equal in their mathematical formula, I am still getting false.
I checked the values, and they are equal. I also read online, that it could be that the number is treated as text, but I just don't understand how could this be if I made math operations on the columns.
I will try to use the value function on both columns and see if that helps.
Any suggestions are appreciated.
Thanks in advance.

 

[Joe4]

You could also have something like this going on: Floating-point arithmetic may give inaccurate result in Excel - Office
The easiest way to correct that is to employ the ROUND function in your formulas.

If you need help with that, please post your current formula, and a few sample values.