Floor
This article describes the formula syntax and usage of the FLOOR function in GoFormz.
Rounds number down, toward zero, to the nearest multiple of significance.
Syntax
FLOOR(number, [significance])
The FLOOR function syntax has the following arguments:
- Number (Required) The numeric value you want to round.
- Significance (Required) The multiple to which you want to round.
Remarks
- If either argument is nonnumeric, FLOOR returns the NaN error value.
- If the sign of number is positive, a value is rounded down and adjusted toward zero. If the sign of number is negative, a value is rounded down and adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.
Updated almost 2 years ago