:MAXA function calculates the maximum value of a value-Table skills免费ppt模版下载-道格办公

MAXA function calculates the maximum value of a value

Picture and text skills
Case

Returns the maximum value in the parameter list. Text values and logical values (such as TRUE and FALSE) are also evaluated as numbers.
The function MAXA is similar to the function MINA.

Grammar

MAXA(value1,value2,...)

Value1, value2,... are 1 to 30 parameters from which the maximum value needs to be found.

Description

• Parameters can be numbers, blank cells, logical values, or text expressions of numbers. If the parameter is an incorrect value, an error will be generated.

If you cannot include text or logical values in your calculations, use the MAX worksheet function instead.

• If the argument is an array or reference, only the values in the array or reference are used. Blank cells and text values in arrays or references are ignored.

• Arguments containing TRUE are evaluated as 1; arguments containing text or FALSE are evaluated as 0.

• If the argument contains no value, function MAXA returns 0.

In tables, we can use the MAX function when we want to calculate the maximum value of a value.
But if the table contains text data, you need to use the MAXA function.
Unlike the MAX function, in the MAXA function, text values and logical values (such as TRUE and FALSE) are also evaluated as numbers.
Taking this table as an example, we now need to find the maximum value in the left column of data;

￭First, position the cursor on cell C2, click Insert Function-MAXA Function, and click OK;

￭A dialog box will pop up. "Value" refers to the 1~255 parameters that require the maximum value.
Can be filled with numbers, blank cells, logical values and text values,
Arguments containing TRUE are evaluated as 1,
Parameters containing text, FALSE, or blank cells are evaluated as 0;

￭Select A2:A8 (A2 to A8) and click OK;
The maximum value is obtained at this time, and the returned result is 1; in fact, the data list does not contain 1,
But the MAXA function treats TRUE as 1 when calculating, so the maximum value here is 1.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/MAXA-han-shu-ji-suan-shu-zhi-de-zui-da-zhi.html