Computer Applications

Explain the following function:
MAX ( )

27 Likes

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