Question

Explain the MAX() function ? What do you understand by the term 'current cell' ?

Your answer

Explain the MAX() function ? What do you understand by the term 'current cell' ?

​

Answer 1

$\huge\green{\mid{\fbox{\tt{Answer}}\mid}}$

MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value. Unlike MAXA function, the MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.

Explanation:

hope it helps you mate ☺️