Syntax
=ROUNDDOWN(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 ROUNDDOWN
ROUNDDOWN takes 2 required arguments. Type =ROUNDDOWN( 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.
=ROUNDDOWN(3.14159, 3)Result =ROUNDDOWN(-3.14159, 1)Result =ROUNDDOWN(31415.92654, -2)Result Related math functions
- 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.
- ROUNDRounds a number to a given number of digits, halves away from zero.
- 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) + ...
- SIGNReturns 1 for a positive number, -1 for a negative number and 0 for zero.