Which formula gets the smallest value of a range of cells? min max
Answers
Answered by
1
Answer:
To do this task, use the MIN, MAX, SMALL, or LARGE functions.
...
Example.
A
Formula Description (Result)
=MIN(A2:A7) Smallest number in the range (0)
=MAX(A2:A7) Largest number in the range (27)
Answered by
0
Answer:
=MIN(A2:A7) Smallest number in the range (0)
=MAX(A2:A7) Largest number in the range (27)
=SMALL(A2:A7, 2) Second smallest number in the range (4)
=LARGE(A2:A7,3) Third largest number in the range (9)
Explanation:
MARK ME AS BRAINLIEST
Similar questions