describe max() and min()
Answers
Answered by
2
Answer:
The MIN and MAX functions are just what the names imply. MIN will find the lowest number in a range, while MAX finds the largest number in a range. One advantage to these functions is that they can be combined with the IF function.
Answered by
5
Explanation:
Max
It returns the largest value in a given range of cells.
Syntax : =Max(range or numbers)
Example : =Max(A1:A5) gives the output 50
Min
It returns the smallest value in a given range of cells.
Syntax : =Min(range or numbers)
Example : =Min(A1:A5) gives the output 10
Similar questions