Thursday, May 12, 2022

Exact function

Compares two text strings and returns the logical value TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive. Use EXACT to test text being entered into a document.

Syntax

EXACT(text1,text2)

Text1     is the first text string.

Text2     is the second text string.

Examples

Col1

Col2

Formula

Description (Result)

word

word

=EXACT([Col1],[Col2])

Checks whether the strings match (Yes)

Word

word

=EXACT([Col1],[Col2]

Checks whether the strings match (No)

w ord

word

=EXACT([Col1],[Col2])

Checks whether the strings match (No)

No comments:

Post a Comment