EXACT Formula in MS Excel

EXACT Formula in MS Excel

The EXACT formula in MS Excel returns TRUE if two text strings are exactly the same, including case sensitivity, and returns FALSE otherwise.

The syntax of the EXACT formula is as follows:

EXACT(text1, text2)

Where:

• text1: The first text string to compare.
• text2: The second text string to compare.

For example, if you have two text strings in cells A1 and B1, you can use the EXACT formula to compare them:

=EXACT(A1,B1)

This would return TRUE if the text in cells A1 and B1 is exactly the same, including case sensitivity, and return FALSE otherwise.

Note: The EXACT formula is useful for comparing text strings when case sensitivity matters, such as in password verification. If case sensitivity does not matter, you can use the =A1=B1 formula, which returns TRUE if the text in cells A1 and B1 is the same, ignoring case sensitivity.