INT |
INT(number) |
Returns the number rounded down to the nearest integer. |
number | The number you want to round down to an integer. |
REMARKS |
* Positive decimal numbers are rounded down. * Negative decimal numbers are rounded down. * If "number" is not numeric, then #VALUE! is returned. * For positive numbers this is equivalent to the ROUNDDOWN function with "num_digits" set to 0. * You can use the CEILING.MATH function to round up to the nearest integer or multiple. * You can use the FLOOR.MATH function to round down to the nearest integer or multiple. * You can use the MOD function to return the decimal part of a number. * You can use the MROUND function to round to a certain multiple. * You can use the ROUND function to round to a certain number of decimal places or digits. * You can use the ROUNDDOWN function to round down 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 TRUNC function to return a number with any decimal places removed. * The equivalent VBA function is VBA.INT * For the Microsoft documentation refer to support.microsoft.com |
|
1 - What is the number 1.1 rounded down to the nearest integer. 2 - What is the number 1.5 rounded down to the nearest integer. 3 - What is the number 1.9 rounded down to the nearest integer. 4 - What is the number -1.1 rounded down to the nearest integer. 5 - What is the number -1.5 rounded down to the nearest integer. 6 - What is the number -1.9 rounded down to the nearest integer. 7 - What is the number 123.456 rounded down to the nearest integer. 8 - What is the number 123.567 rounded down to the nearest integer. 9 - What is the number -123.456 rounded down to the nearest integer. 10 - What is the number -123.567 rounded down to the nearest integer. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top