EXACT
Description
Determines if two text strings are exactly equal. If so, returns TRUE; otherwise,
returns FALSE. The function is case-sensitive, and it considers spaces.
Syntax
EXACT(
text1
,
text2
)
- text1: The first text to compare.
- text2: The second text to compare.
Example
Formula | Result |
|---|---|
=EXACT(A1,A2)
Where cell A1 contains
6000:salaries and wages
and
A2 contains
6000:Salaries and Wages
.
| FALSE |
Notes
- When comparing a single instance value to a string that visually appears to be the same, the function evaluates them as equal. When comparing a single value in a multi-instance field to a string that visually appears to be the same, the formula evaluates them asnotequal.