Sometimes we need to customize the output, means instead of “TRUE” or “FALSE” if we need any other output to be shown then we need to use the equal function along with “IF”.
For example, if we need “Name is Matching” text instead of “TRUE” and “Name is not Matching” text instead of “FALSE” then we need to follow below:
Syntax: =IF(A2=B2,"Name is Matching", "Name is not Matching")
Here “IF” excel function is used to get the customized result. We are comparing cells “A2, B2” and if both cells are matching then output will be “Name is Matching” whereas if cells are not matching then output will be “Name is not Matching”