This tutorial continues Calc Basics V and now we will learn a new formula namely ROUND. With this, we can simplify numbers. For example, we will simplify student scores based on the previous AVERAGE exercise. As a reminder, if you haven't followed this LibreOffice Calc series, read the first and second parts here. Now let's exercise again.

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

Dataset

Write a new table like below into a new document calc-06-round.ods. Give the sheet name ROUND. Notice that the table spans across B2:H23. Notice also that the score data spans across E2:H23 from MATH to SOCIAL columns.

AVERAGE

Before going into the formula, first we need to create average scores. We will demonstrate this both ways horizontally and vertically. You should remember the earlier formula AVERAGE we had learned several series ago.

1. Put cursor at I3.

2. Type the formula =AVERAGE(E3:H3)

3. This should give you ABI's average score horizontally.

4. Drag it down to calculate all scores from ABI to CLAUDIA.

5. Name the column HORIZONTAL AVERAGE.

6. Put cursor at E24.

7. Type the formula =AVERAGE(E3:E23)

8. This should give you all students average score in MATH.

9. Drag it to right to calculate all student average scores of ENGLISH, SCIENCE, and SOCIAL. 

10. Name the line VERTICAL AVERAGE.

11. Finished the dataset.

ROUND

Now we will do our job.

1. Put cursor at J2

2. Type the formula =ROUND(I2)

3. This should give you ABI's rounded score of his average score horizontally.

4. Drag it down to calculate all student rounded scores from their respective averages.

5. Name the column ROUNDED HORIZONTALLY.

6. Pur cursor at E25

7. Type the formula =ROUND(E24)

8. This should give you MATH's rounded score of all students average MATH score.

9. Drag it to the right to calculate other subjects as well.

10. Name the line ROUNDED VERTICALLY.

11. Finished the rounded scores.

Final Result

To view all the formulas temporarily, go to menu View > Show Formula. 

To this point, you've learned about how to round numbers using =ROUND() formula. Next time, we will learn about VLOOKUP, the formula everyone cherishes. See you next time.