MAX Function

Returns the highest number or latest date.
Sample Usage
MAX(Cost1:Cost5)
Syntax
MAX(
  • value1
  • [
    • value2
      • ​
    • ...
    ]
)
  • value1
    —
    The number or range from which you want the highest value.
    • value2
      • ​
    • ...
    —[optional]
    Additional numbers or ranges.
Usage Notes
  • When referencing dates, you must use MAX in a Date column. See Column Types for more information on Date columns.
     
Related Functions
MIN
AVG
AVGW
Related Articles
Use the Best Column Type for Your Data
Was this article helpful?
YesNo