EXACT
Checks to see if two text values are identical.
TextText Processing
What it does
Compares two text strings and returns TRUE if they are exactly the same (case-sensitive).
Syntax
EXACT(text1, text2)
Arguments
text1(text) — First string.text2(text) — Second string.
Examples
Compare Case
Compare 'Apple' and 'apple'.
FORMULA
=EXACT("Apple", "apple")RESULT
false
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 |