Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
ROUND
7.9167 becomes 7.92. The 2 means keep 2 decimal places.
Try this lesson free →Example
ROUND keeps as many decimal places as you ask for:
=ROUND(E2,2)| Day | Product | Qty | Revenue | Price each | Rounded |
|---|---|---|---|---|---|
| Mon | Phone case | 12 | 95 | 7.9167 | |
| Tue | Charger | 7 | 118 | 16.857 | |
| Wed | Earbuds | 6 | 209 | 34.833 | |
| Thu | Phone case | 15 | 119 | 7.9333 | |
| Fri | Screen guard | 9 | 100 | 11.111 |
Key points
ROUND( , 2)Keeps 2 decimal places: =ROUND(7.9167,2) shows 7.92.
ROUND( , 0)0 decimal places gives a whole number: =ROUND(34.833,0) shows 35.
Round a sumWrap a calculation: =ROUND(D2/C2,2) works out the price, then rounds it.
Put together: =ROUND(E2,2) keeps 2 decimals, =ROUND(E2,0) gives a whole number, and =ROUND(D2/C2,2) rounds a calculation.
Practice
1. In F3, round Tuesday's price each (E3) to 2 decimal places.
=ROUND(E3,2)2. In F4, round Wednesday's price each (E4) to a whole number.
=ROUND(E4,0)3. In F5, work out Thursday's price each from scratch, revenue (D5) divided by quantity (C5), rounded to 2 decimal places.
=ROUND(D5/C5,2)4. In F2, round Monday's price each to 2 decimal places.
=ROUND(E2,2)5. In F6, round Friday's price each to 1 decimal place.
=ROUND(E6,1)Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →