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)



ADVERTISEMENT
ADVERTISEMENT