IF Function

[clco1748]

Hello. I am using Microsoft 365 Excel and have the following formulas in a worksheet:

=IF(C11=C17,True)   &  =IF(F11=F31, True).  The second formula using the F column is working but I can't determine why the first formula using the C column is returning a value of FALSE.

Any help would be appreciated.

     

[#2 · Accepted solution]

@clco1748 First of all, you don't need the IF. Just use =C11=C17. It will display TRUE if both cells are exactly the same and FALSE if they are not. I guess that you have rounding issue. Try =ROUND(C11,2)=ROUND(C17,2)