[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

EXACT

Syntax:

EXACT ( string-1 , string-2 )

Description: Performs a case-sensitive comparison of string-1 and string-2.

Arguments:

Name

Type

Description

string-1

text

The two strings to be compared.

string-2

text

 

Return Type and Value: logical – TRUE if string-1 and string-2 have the exact same length and contents; otherwise, FALSE.

[Example:

EXACT("ABC","ABC") results in TRUE
EXACT("ABC","ABCD") results in FALSE
EXACT("Abc","aBC") results in FALSE
EXACT("","") results in TRUE

end example]