EXACT Function Explained
The EXACT function in Microsoft Excel is used to compare two text strings and determine if they are exactly the same. It returns TRUE if the strings are identical, and FALSE if they are not. The EXACT function is case-sensitive, meaning that uppercase and lowercase letters must match exactly. The syntax for the EXACT function is EXACT(text1, text2), where text1 and text2 are the two strings to be compared.
EXACT Function Syntax
EXACT(text1, text2)
- text1: The first text string to compare.
- text2: The second text string to compare.
The EXACT function compares two text strings and returns TRUE if they are exactly the same, and FALSE if they are not.