Apple Numbers '08 - Manual (Page 231)

Chapter 12 Dictionary of Functions 231
FALSE
The FALSE function returns the Boolean value FALSE. It is included so you can use
spreadsheets created with some older spreadsheet applications. You can specify a
Boolean value of FALSE by simply typing “false” (without quotation marks) into a cell or
function argument.
FALSE()
 No arguments (but you must include the parentheses).
Notes
You can type the word FALSE into a cell or formula instead of using the FALSE()
function.
FIND
The FIND function finds the starting position of one string within another. The search is
case sensitive and spaces are counted. Wildcards are not allowed.
FIND(target, string, [start])
 target: The text you want to find. If you’re including the actual text as the argument,
surround it with quotation marks.
 string: The text you want to search. If you’re including the actual text as the
argument, surround it with quotation marks.
 start: Optional; a number specifying the character position in the target string where
you want to start the search. If omitted, the search starts with the first character in
target.
Notes
To use wildcards in your search, use the SEARCH function.
Examples
FALSE() returns the Boolean value FALSE.
AND(1,FALSE()) returns the Boolean value FALSE.
Examples
FIND("e","where on earth") returns 3 ("e" is the third character in the string "where on earth").
FIND("e","where on earth", 8) returns 10 ("e" in earth is the first "e" found starting from character 8, the
"n" in "on").