Math & trig
ROUND function
Round to N decimals. ROUND works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=ROUND(value, [digits]) | Argument | Use |
|---|---|
value | required |
digits | optional |
Example
Round the average to whole units.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Status | Amount | Date |
| 2 | #1001 | Acme Ltd | North | Paid | 1200 | 2026-01-14 |
| 3 | #1002 | Blue Fox | South | Open | 450 | 2026-01-20 |
| 4 | #1003 | Acme Ltd | North | Paid | 980 | 2026-02-03 |
| 5 | #1004 | Cedar & Co | East | Overdue | 2300 | 2026-02-11 |
| 6 | #1005 | Blue Fox | South | Paid | 610 | 2026-03-02 |
| 7 | #1006 | Delta BV | West | Open | 1750 | 2026-03-09 |
| 8 | 1,215 |
Result computed by the Sheets formula engine.
On live data
In Sheets, ROUND sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
Try it in a free calculator
Percentage calculatorWork out a percent of a number, what percent one number is of another, and the percent change between two values, with the spreadsheet formula for each..Profit margin calculatorCalculate gross profit margin and markup from cost and price, or the selling price for a target margin or markup, with the spreadsheet formula for each..
More math & trig functions
SUMSum of valuesSUMIFSum where one criterion matchesSUMIFSConditional sumSUMPRODUCTSum of element-wise productsABSAbsolute valueACOSArccosine, in radiansACOSHInverse hyperbolic cosineACOTArccotangent, in radiansACOTHInverse hyperbolic cotangentAGGREGATEAggregate that can skip error valuesARABICRoman numerals as a numberASINArcsine, in radians
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.