3.5 ROUND Family and RANK
| Function | Example | Result |
|---|---|---|
ROUND(number, digits) |
=ROUND(333.2857,2) |
333.29 |
ROUNDUP / ROUNDDOWN |
=ROUNDUP(12.1,0) / =ROUNDDOWN(12.9,0) |
13 / 12 |
ROUND to nearest 10 |
=ROUND(1299,-1) |
1300 |
MROUND(number, multiple) |
=MROUND(47,5) |
45 |
CEILING.MATH(number, significance) |
=CEILING.MATH(47,10) |
50 |
FLOOR.MATH(number, significance) |
=FLOOR.MATH(47,10) |
40 |
INT / TRUNC |
=INT(-2.5) / =TRUNC(-2.5) |
-3 / -2 |
RANK.EQ(number, ref, [order]) – 0 or omitted = largest gets rank 1; 1 = smallest gets rank 1. RANK.AVG gives average rank for ties. (Old RANK still works for compatibility.)
| Formula | Result |
|---|---|
=RANK.EQ(G3,$G$2:$G$11) (₹270) |
2 |
=RANK.EQ(H7,$H$2:$H$11,1) (8 mins, fastest) |
1 |
Ravindra Bagale's Tip
Khup students Decrease Decimal button ne number "round" kartat – pan to fakt display badalto, value tashich rahate aani totals madhe paise farak yeto. Kharach round karaycha asel tar ROUND function vapra. RANK madhe range la $ lavayla visru naka.
Practice task
Round every delivery fee to the nearest ₹5 with MROUND. Rank stores by sales (largest = 1) and by average delivery time (smallest = 1).