EXACT

Definition: EXACT is a function that compares two text strings and returns TRUE if they are identical, otherwise it returns FALSE.

Syntax: =EXACT(text1, text2)

Situation: This formula is suitable when you need to compare two text strings and determine if they are identical.

Example: If you have two text strings “apple” and “APPLE”, the formula =EXACT(“apple”, “APPLE”) returns FALSE since they are not identical.