How to use the Excel EXACT function

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:

EXACT 1 - How to use the Excel EXACT function

Syntax: =EXACT(A2,B2)

Result:

EXACT - How to use the Excel EXACT function

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

Add a Comment

Your email address will not be published. Required fields are marked *