The EXACT Function is categorized under Excel TEXT functions. The function helps to test if two or more than two supplied text strings or values are exactly equal and, if so, returns TRUE. Otherwise, it returns FALSE. The EXACT function is case-sensitive.
Syntax: =EXACT(text1, text2)
The EXACT function syntax has the following arguments:
- text1: It is the first string that we wish to compare.
- text2: It is the second text string.
Example: Let’s look at some Excel EXACT function examples and explore how to use the EXACT function as a worksheet function in Microsoft Excel:
Syntax: =EXACT(A2,B2)
Result:
Syntax: =EXACT(A3,B3)
Result: FALSE
Syntax: =EXACT(A4,B4)
Result: FALSE
Syntax: =EXACT(A5,B5)
Result: FALSE
Syntax: =EXACT(A6,B6)
Result: TRUE
Syntax: =EXACT(A7,B7)
Result: TRUE
