Suppose, if the cell values between A2 and C2 are different, the logic returns TRUE, then we can decide to replace it with the text “ Not Matched” and if the logic is FALSE then it is replaced with the text “ OK“. (03) We can arrange the logic in a different manner and based on the logic we should arrange the arguments respectively. Suppose, if the cell values between A2 and C2 are the same, the logic returns TRUE, then we can decide to replace it with the text “ OK” and if the logic is FALSE then it replaces with the text “ Not Matched“.Įxtend the formula downward till to the end of the range to get the results. (02) We can use text strings in the IF function. In this case, it will show TRUE which means the value in cell A2 is equal to the value in cell C2, otherwise, it will show as FALSE. Then simply press Enter or Ctrl+Enter, which will show either TRUE or FALSE. But in this case, we should mention them within double quotation (” “). (01) We can use the IF function when we try to mention TRUE or FALSE. Please keep in mind that the IF formula returns the result based on criteria that may not be case-sensitive, which means criteria text may be upper, lower, proper case doesn’t matter at all.īefore going to the formula, we will focus on the syntax for the IF function. If required, we can use the IF function to replace TRUE or FALSE with a specific text string.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |