If the number 0 is entered in the order argument of the RANK.AVG function the numbers will appear in ascending order.

Name: If the number 0 is entered in the order argument of the RANK.AVG function the numbers will appear in ascending order.
Brand: Quizplus
Rating: 4.9 (31 reviews)

Question

Quizplus · Accepted Answer

If the number 0 is entered in the order argument of the RANK.AVG function, the function will sort the numbers in descending order. To sort the numbers in ascending order, the order argument should be omitted or set to 1.

If the Number 0 Is Entered in the Order Argument