Apple numbers User Manual

 Dictionary of Functions

 

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.
  

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.
  

FALSE() returns the Boolean value FALSE.

AND(1,FALSE()) returns the Boolean value FALSE.

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").