ROUND Function in Excel: Syntax, Examples and Free Practice
ROUND is an Excel Math & Trig function. Rounds a number to a set number of decimal places.
ROUND syntax
Arguments
number: A number to use in the calculationnum_digits: How many decimal places to round to
When to use ROUND
ROUND is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice ROUND online, free
Open the live Excel-style spreadsheet and try ROUND yourself. No Excel install or sign-up needed to start.
Practice ROUND now →Watch: ROUND in Excel
Learn more
Read the tutorial: ROUND, ROUNDUP and ROUNDDOWN.
ROUND practice questions
- Using ROUND, round the amount in B2 to 2 decimal places and put it in C2.
- Round each weight to the nearest whole kg and put the results in C2 to C4.
- Using ROUND, round each price to the nearest 10 and put the results in C2 to C4.
- Find the GST on each invoice at the rate in E2, rounded to 2 decimals, and put it in C2…
- Round each price to the nearest 5 and put the results in C2 to C4.
- Find the average mark rounded to 1 decimal and put it in D2.
- The price after the discount in E2 must be a whole rupee amount. Find the final price…
- Round each line total (Qty x Price) to a whole number first, then add the rounded lines…
- Item prices (before tax) are in B2:B7. Calculate the total GST at 18% on all items,…
- Actual sales are in B2:B6 and budget in C2:C6. Show the variance as a decimal ((actual -…
- Revenue was in B2 (120000) six years ago (B4 = 6) and is in B3 (295000) now. Find the…
More Math & Trig functions
Frequently asked questions
What does the ROUND function do in Excel?
Rounds a number to a set number of decimal places.
What is the syntax of ROUND in Excel?
The syntax is =ROUND(number, num_digits). number: A number to use in the calculation; num_digits: How many decimal places to round to.
Where can I practice ROUND online for free?
Open the free live spreadsheet on Cellgrids and try ROUND yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts