MAXA
Formulas / MAXAFind the largest numeric value in a range.
=MAXA(value1, [value2], …)
- value1 - required
- value2 - [OPTIONAL]
- value3 - [OPTIONAL]
- value4 - [OPTIONAL]
- value5 - [OPTIONAL]
- value6 - [OPTIONAL]
- value7 - [OPTIONAL]
- value8 - [OPTIONAL]
- value9 - [OPTIONAL]
- value10 - [OPTIONAL]
- value11 - [OPTIONAL]
- value12 - [OPTIONAL]
- value13 - [OPTIONAL]
- value14 - [OPTIONAL]
- value15 - [OPTIONAL]
Examples
=MAXA(12,17,25,11,23)The example returns 25. This is because MAXA is a function used to determine the maximum value of a given set of numbers. In this example, 25 is the maximum value, so it is returned.
=MAXA(5,10)The example returns returns 10. This is because 10 is the highest value in the set of numbers, so it is returned as the maximum value.
=MAXA(A1:A10)The example returns returns the maximum value in A1:A10. MAXA is used to determine the highest numerical value in a given range of cells. In this example, the function will return the highest value in A1:A10.
Summary
The MAXA function returns the largest value in a list of numerical, name, array, and reference arguments. It ignores empty cells and text values in arguments that are arrays or references.
- The MAXA function returns the largest value in a range of numbers and takes multiple arguments, which can be numbers, strings, arrays, or references.
- MAXA ignores empty cells, logical values, and text values.
- The MAX function allows for the ignoring of logical values and text values.
- MAXA evaluates text as a 0.
Frequently Asked Questions
What is the MAXA Function?
The MAXA Function is a built-in Sourcetable formula that finds the greatest value in a list of arguments. This could be a list of numbers, names, arrays, or references.
What types of arguments can I use with the MAXA Function?
You can use numbers, names, arrays, or references as arguments. You can also use text representations of numbers or logical values.
Does MAXA Function ignore empty cells and text values?
Yes, MAXA Function ignores empty cells and text values in the arguments.
Does MAXA Function count logical values and text representations of numbers entered into the arguments?
Yes, MAXA Function counts logical values and text representations of numbers entered into the arguments.
What does the MAXA Function return?
The MAXA Function returns 1 for the largest value in the arguments.
