[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
EXACT ( string-1 , string-2 )
Description: Performs a case-sensitive comparison of string-1 and string-2.
Arguments:
Name |
Type |
Description |
string-1 |
The two strings to be compared. | |
string-2 |
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]