Difference between revisions of "Documentation/How Tos/Calc: EXACT function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
Line 2: Line 2:
  
 
== EXACT ==
 
== EXACT ==
returns TRUE if two text strings are identical  
+
returns <tt>'''TRUE'''</tt> if two text strings are identical  
  
 
=== Syntax: ===
 
=== Syntax: ===

Revision as of 09:48, 31 December 2007


EXACT

returns TRUE if two text strings are identical

Syntax:

EXACT(text1; text2)

returns TRUE if the text strings text1 and text2 are exactly the same (including case).

Example:

EXACT("red car"; "red car")

returns TRUE.

EXACT("red car"; "Red Car")

returns FALSE.

See also:

FIND, SEARCH, ISTEXT

Text functions

Information functions

Personal tools