EXACT

Name

Exact

Description

Returns 1 (True) if two strings are the same; otherwise, 0 (False).

Syntax

EXACT(text1, text2)

Remarks

Compares the first string, the text1 argument, to the second string, text2.

Although the EXACT function is case-sensitive, it ignores formatting differences.

Data Type

Accepts string data for both arguments. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

EXACT(A3,A5)
fpSpread1.Formula = "EXACT(""SPREAD"",""spread"")" equals 0 (False)