Manuals/calci/FLOOR

Revision as of 15:07, 2 December 2013 by Swapna (talk | contribs)

FLOOR(number, significance)

  • Where 'number' is the numeric value to round and
  • significance' is the multiple to round the number.

FLOOR() rounds the number down towards zero, to its nearest multiple of significance.

Description

FLOOR(number, significance)

For Example, FLOOR (3.5, 2) returns 2.

  • Calci returns an error value if the argument is nonnumeric.
  • Calci returns an error message if 'number' and 'significance' have different signs.
  • If the number is an exact multiple of significance, rounding will not be done. Calci will display the same number as output.

Examples

Function Output
FLOOR(1000.34)
FLOOR
FLOOR
FLOOR

See Also

References