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.