62.3k views
0 votes
Column A contains numbers from rows 1-20. You can use the formula ----?---- to find the value of the largest number divided by the total number of values.

User Iabbott
by
8.5k points

2 Answers

3 votes

Answer:

=MAX(A1:A20)/COUNT(A1:A20)

Step-by-step explanation:

Got it right on plato

User Bazzel
by
7.3k points
2 votes

Using Excel formulas
=LARGE(A1:A20, 1)/COUNT (A1:A20)

Count (Ai:An) Function that allows to count the total number of values in a cells range between Ai and An that contain only numbers.

Large (Ai:An, k) Function that allows to find the value of the largest number in a cells range between Ai and An, the number k determine the k-th largest value

User SathOkh
by
8.7k points

No related questions found