Apple numbers User Manual
Chapter 12
Dictionary of Functions
247
Notes
When searching for text, case is ignored.
When searching for text, case is ignored.
MATCH works only on a range that is part of a single row or column; you can’t use it to
search a two-dimensional table.
search a two-dimensional table.
MAX
The MAX function finds the largest number in a set.
MAX(number, [number, . . .])
 number: A series of numbers, numeric expressions, or references to cells containing
numbers or numeric expressions.
Notes
Cells that don’t contain numbers are ignored.
Cells that don’t contain numbers are ignored.
Text entered directly in the arguments results in an error.
Examples
Given the following table:
MATCH(40, A1:A5) returns 4.
MATCH(40, E1:E5) returns 1.
MATCH(35, E1:E5, 1) returns 3 (30 is the largest value less than or equal to 35).
MATCH(35, E1:E5, -1) returns 1 (40 is the smallest value greater than or equal to 35).
MATCH(35, E1:E5, 0) displays an error (no exact match can be found).
Examples
MAX(5, 5, 5, 5, 6) returns 6.
MAX(1, 2, 3, 4, 5) returns 5.