Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

MAXA

Returns the maximum value in a dataset.

 

Sample Usage

MAXA(20,30)
MAXA(A2:A6)
MAXA(A1:B2,5)

Syntax

MAXA(value1, [value2, ...])

  • value1 - The first value or range to consider while calculating the maximum value.
  • value2, .. - [OPTIONAL] Additional numbers or ranges to consider.

Examples

MAXA(20,30) returns a value of 30.
MAXA(A2:A6) returns the largest value in the ranges A2 through A6.
MAXA(A1:B2,5) returns the largest value among the values contained in cells A1 through B2 and the number 5.

 

Notes

  • Arguments can be numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE.
  • Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
  • Cells with text will be assigned the numeric value 0 (zero) for the purpose of this function.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAX function.