Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting > Chapter 10: Conversion Functions > Comparing Strings (EXACT)

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

EXACT compares two strings and returns 1 if they are exactly the same or 0 if they are not. For example:

=EXACT("OpenOffice.org"; "OpenOffice.org")

returns 1, while

=EXACT("OpenOffice.org"; "openoffice.org")

returns 0.

Figure 10-8. Sample result of the EXACT function

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.