Computer Applications
Explain the following function:
MAX ( )
Spreadsheet
27 Likes
Answer
This function returns the highest value from among the specified cells in the active cell.
Its syntax is:
=MAX(number1, number2, …….) where argument type is Number and return type is Number.
To know the highest of the cell values ranging from A1, A2, A3, …….. to An, the function will be written as:
=MAX(A1, A2, A3, ……., An)
OR
=MAX(A1:An)
Answered By
15 Likes