A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $6

Question

3 years ago

7

50, and $600. What function could be used to return the third largest value

1 answer:

ivolga24 [154] · Answer 1 · 2022-02-20T03:25:42+03:00

Answer:We use the Large Function. the general formula is =LARGE(first cell:last cell,3) .Please refer to the explanation section for details

Explanation:

Let us assume

A 1 = $1,250, A 2 = $1,090, A 3 = $985, A 4 = $985, A 5 = $880, A 6 = $756, A 7 = $675, A 78= $650, and A 9 =$600

Using the Large function on excel to return the third largest value, on the formula bar we have the following formula;

=LARGE(A1:A2,3)