ROUNDDOWN |
ROUNDDOWN(number, num_digits) |
Returns the number rounded down to a certain number of decimal places or digits. |
number | The number you want to round down (towards zero). |
num_digits | The number of decimal places you want to round the number to. |
REMARKS |
* Positive decimal numbers are rounded down to the nearest integer. * Negative decimal numbers are rounded down to the nearest integer. * This function is identical to the ROUND function, except that it always rounds a number down. * If "number" is not numeric, then #VALUE! is returned. * If "num_digits" > 0, then "number" is rounded down to the specified number of decimal places. * If "num_digits" = 0 then "number is rounded down to the nearest integer. * If "num_digits" < 0, then "number" is rounded down to the left of the decimal point. * If "num_digits" is not numeric, then #VALUE! is returned. * You can use the ROUND function to round to a certain number of decimal places or digits. * You can use the ROUNDUP function to round up to a certain number of decimal places or digits. * You can use the FLOOR.MATH function to round down to the nearest integer or multiple. * You can use the CEILING.MATH function to round up to the nearest integer or multiple. * You can use the INT function to return a number rounded down to the nearest integer. * You can use the MROUND function to round to a certain multiple. * You can use the EVEN function to round up to the nearest even integer. * You can use the ODD function to round up to the nearest odd integer. * For the Microsoft documentation refer to support.microsoft.com |
|
1 - What is the number 1.1 rounded down to 0 decimal places. 2 - What is the number 1.5 rounded down to 0 decimal places. 3 - What is the number 1.9 rounded down to 0 decimal places. 4 - What is the number -1.1 rounded down to 0 decimal places. 5 - What is the number -1.5 rounded down to 0 decimal places. 6 - What is the number -1.9 rounded down to 0 decimal places. 7 - What is the number 123.456 rounded down to 0 decimal places. 8 - What is the number 123.567 rounded down to 0 decimal places. 9 - What is the number -123.456 rounded down to 0 decimal places. 10 - What is the number -123.567 rounded down to 0 decimal places. 11 - What is the number 123.456 rounded down to 4 decimal places. 12 - What is the number 123.456 rounded down to 3 decimal places. 13 - What is the number 123.456 rounded down to 2 decimal places. 14 - What is the number 123.456 rounded down to 1 decimal place. 15 - What is the number 123.456 rounded down to -1 decimal places. 16 - What is the number 123.456 rounded down to -2 decimal places. 17 - What is the number 123.456 rounded down to -3 decimal places. There are only 3 digits on the left of the decimal place. 18 - What is the number 123.456 rounded down to -4 decimal places. There are only 3 digits on the left of the decimal place. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top