Function EXACT

Return TRUE if the values are exactly equal, FALSE otherwise

Usage

EXACT(text1, text2)

text1	(Required) Value to compare
text2	(Required) Value to compare

Example	With these variables	Result
EXACT(word, “hello”)	word is "hello"	TRUE
EXACT(word, “moon”)	word is "hello"	FALSE
EXACT(word, “case insensitive”)	word is "CASE INSENSITIVE"	FALSE
EXACT(word1, word2)	word1 is " extra space ignored " word2 is "extra space ignored"	FALSE
EXACT(“Hello WORLD”, word)	word is "Hello WORLD"	TRUE

Unlike the = operator, this function is case sensitive, so “A” is considered different from “a”.

Unlike the = operator, this function is extra space sensitive, so "hello world" is considered different from " hello world ".