The Round-Off Formula in Excel is a simple and sophisticated method used to minimize complications while representing the decimal values in your data. Experts use the Round-Off Formula in Excel to round off the lengthy decimal values to the nearest whole.

Round-off Formula in Excel - Round Up

In the same way as ROUND, but it always rounds numbers down. The following method is used to round down ex: 3.14159 to three decimal places: =ROUNDDOWN(3.14159,3), which will result in 3.141.

The round-off formula in Excel for roundup will help the user round off the decimal value to the nearest higher whole number. For example, 1.8930 will be rounded up to the nearest highest value as 1.9.

PCP in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
PCP in Business Analysis

Now, follow the steps below to calculate the round-off formula in Excel to round up the values.

This example considers the student data set where you will try to round up the percentage values of the students

Create a new column and rename it as “round-off percentage” value. 

Now, select the first cell and type in the formula = ROUND(M2,2) to round up the first two decimal places, as shown in the image below.

Select the roundup function from the options provided.

Round-Off-Formula-in-Excel-image-1

Press enter and drag the cell throughout the column to apply the formula to the whole column as shown in the image below.

Round-Off-Formula-in-Excel-image-2

Round-off Formula in Excel - Round down

The round-off formula in Excel for round down will help the user round off the decimal value to the nearest lower whole number. For example, 1.8630 will be rounded up to the nearest highest value as 1.8.

Now, follow the steps below to calculate the round-off formula in Excel to round up the values.

This example considers the student data set where you will try to round up the percentage values of the students

Create a new column and rename it as round-off percentage value. 

Now, select the first cell and type in the formula = ROUND(M2,2) to round down the first two decimal places, as shown in the image below.

Select the round-down function from the options provided.

Round-Off-Formula-in-Excel-image-3

Press enter and drag the cell throughout the column to apply the formula to the whole column, as shown in the image below.

Round-Off-Formula-in-Excel-image-4

FREE Business Analytics With Excel Course

Start your Business Analytics Learning for FREEStart Learning
FREE Business Analytics With Excel Course

With that, you have come to an end of this tutorial on “Everything you need to know about the Round-Off Formula in Excel?”

Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. Enroll now!

Next Steps

"Charts in Excel" can be your next stop. Generating visually appealing charts to represent the data insights is a crucial method in business analytics.

Are you looking for more information on Microsoft Excel or interested in Business Analytics?

Then consider taking a quick walk-through of the Business Analytics certification course offered by Simplilearn which is career oriented training and certification. This training is dedicated to guiding you through the basic concepts of data analysis and statistics that will help you devise insights from available data to present your findings using executive-level dashboards and help you come up with data-driven decision-making.

Have any questions for us? Please feel free to let us know in the comments section below and our team of experts will be happy to resolve all your queries.

About the Author

Shruti MShruti M

Shruti is an engineer and a technophile. She works on several trending technologies. Her hobbies include reading, dancing and learning new languages. Currently, she is learning the Japanese language.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
  • *According to Simplilearn survey conducted and subject to terms & conditions with Ernst & Young LLP (EY) as Process Advisors