Syntax
=ROUND(number, num_digits)Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The number to round |
num_digits | Required | Digits after the decimal point (negative rounds to the left of it) |
How to use ROUND
ROUND takes 2 required arguments. Type =ROUND( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=ROUND(2.15, 1)Result =ROUND(-1.475, 2)Result =ROUND(21.5, -1)Result Related math functions
- RANDReturns a random number from 0 up to (not including) 1, new on every recalculation.
- RANDARRAYReturns an array of random numbers; you choose the size, the range and whether they are whole numbers.
- RANDBETWEENReturns a random whole number between two numbers (both included).
- ROMANConverts a number to Roman numerals as text; form 0 is classic and 1 to 4 are ever more concise.
- ROUNDDOWNRounds a number toward zero to a given number of digits.
- ROUNDUPRounds a number away from zero to a given number of digits.
- SECReturns the secant of an angle given in radians.
- SECHReturns the hyperbolic secant of a number.
- SERIESSUMReturns the sum of a power series: a1*x^n + a2*x^(n+m) + ...