Syntax and usage of function Maxa used in Excel

Function Name: MAXA

function function: Returns the maximum number of values in a dataset.

function attribute: It differs from Max in the calculation of literal and logical values (such as true and false) as numbers. And Max only calculates numbers.

function syntax: MAXA (value1,value2, ...)

Parameter introduction: Value1,value2, ... 1 to 30 parameters from which you want to find the maximum number.

Example one:

If A1:a5 contains 0, 0.2, 0.5, 0.4, and true, then: MAXA (A1:A5) returns 1.

Example two:

If the A1:A5 contains 1,2,9, the Volkswagen computer, good, then Maxa (A1:A5) returns 9.