Formula Functions > Functions D to G > EXACT |
This function returns true if two strings are the same; otherwise, false.
EXACT(text1,text2)
The arguments are text strings.
This function compares the string in the first argument to the string in the second argument.
Although this function is case-sensitive, it ignores formatting differences.
Accepts string data for both arguments. Returns boolean data (true or false).
EXACT(A3,A5)
EXACT(R3C1,R5C1)
EXACT(""SPREAD"",""spread"") gives the result FALSE
This function is available in product version 1.0 or later.