Skip to main content

EXACT function

The EXACT function is one of the text and data functions. Is used to compare data in two cells. The function returns TRUE if the data are the same, and FALSE if not.

Syntax​

EXACT(text1, text2)

The EXACT function has the following arguments:

ArgumentDescription
text1(2)Two text strings you want to compare.

Notes​

The EXACT function is case-sensitive.

How to apply the EXACT function.

Examples​

There are two arguments: text1 = A1; text2 = B1, where A1 is MyPassword, B1 is mypassword. So the function returns FALSE.

EXACT Function: FALSE

If we change the A1 data converting all the uppercase letters to lowercase, the function returns TRUE:

EXACT Function: TRUE