Excel EXACT() Function
The EXACT() function in excel checks whether the specified values (texts, numbers) are exactly the same or not. It returns a Boolean value TRUE if the compared values are same, else it will return FALSE. It is a case-sensitive function.
Syntax
EXACT(Text1, Text2)
Parameter
Text1 (required)- This parameter represents the first string which you want to check.
Text (required)- This parameter represents the second string which you want to test against.
Category
Text
Return
This function returns a Boolean value TRUE if the compared values are the same, else it will return FALSE.
Example 1
Objective: Using the EXACT function, evaluate whether the values specified in Col A and Col B are equal or not.
| Col A | Col B | Result | Formula |
| EXCEL | EXCEL | TRUE | =EXACT(A19,B19) |
| EXCEL | Excel | FALSE | =EXACT(A20,B20) |
| 12345 | 12345 | TRUE | =EXACT(A21,B21) |
| 1 234 | 1234 | FALSE | =EXACT(A22,B22) |
NOTE: You will notice, the result of ROW 20 is FALSE. It is so because the EXACT function is case-sensitive. The first value is in the upper case (EXCEL), whereas the second one (Excel) is a combination of the upper and lower case.
Example 2
Objective: Write a formula using EXACT to check if the values in Col A and Col B are the same or not
| Col A | Col B | Results | Formula |
| EQUAL | EQUal | FALSE | =EXACT(A30,B30) |
| TEST | TEST | TRUE | =EXACT(A31,B31) |
| 1234 | 1234 | TRUE | =EXACT(A32,B32) |
| 1.1 | 100.1 | FALSE | =EXACT(A33,B33) |