# 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.

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)