Version: 2.2.1 +
The formula 'Floor' rounds a number down to the nearest integer (whole number). The formula 'Floor' always rounds the number down and not up.
The difference between the formula 'Floor' and the formula 'Round' is that the formula 'Round' does round to the nearest integer, up or down. The formula 'Floor' only rounds down to the nearest integer. The difference between the formula 'Floor' and the formula 'RoundDown' is that with the formula 'Floor' you can't specify the number of digits and the result of the formula 'Floor' can be used as an integer where the result of the formula 'RoundDown' is a real number.
Number: here you refer to or fill in the number that has to be rounded down.
In the following example you can see how the formula 'Floor' works.
- Round: The formula 'Round' for a double rounds a number to a specified number of digits. The formula 'Round' for an integer rounds a real number to the nearest even integer.
- RoundDown: The formula 'RoundDown' rounds a number down to a specified number of digits.
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.