Manuals/calci/FLOOR

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.

FLOOR (-4.6, -2) returns -4.

• Calci returns an NaN error message 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.
• If significance value is not mentioned, Calci assumes it to be 1.
• This function can also be used for array of numbers in form of equation as-

 a) FLOOR(3.33..6.33,0.1) where x varies from 3.33 to 6.33 and displays output to multiples of 0.1. 
Displays 3.3,4.3,5.3,6.3 as output.

 b) 2.5..4.5|FLOOR(x+2,2)| where x varies from 2.5 to 4.5 , 
adds value 2 and displays output to multiples of 2. Displays 4,4,6 as output. 

Examples

Function	Output
FLOOR(55.55,5)	55
FLOOR(1000.34,3)	999
FLOOR(22.3)	22
FLOOR(-143.56,-1)	-143

Related Videos

FLOOR AND CEILING

See Also

• CEILING

• INT

• ROUND

• ROUNDUP

• ROUNDDOWN

• TRUNC

References

• Rounding
• FLOOR Function

• List of Main Z Functions

• Z3 home