Revision as of 16:23, 15 June 2018

FLOOR(Number, Significance)

FLOOR() rounds the number down towards zero, to its nearest multiple of 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.

@@ Line 1: / Line 1: @@
-=FLOOR(number, significance)=
+=FLOOR(Number, Significance)=
-*Where 'number' is the numeric value to round and
+*Where 'Number' is the numeric value to round and
-*'significance' is the multiple to round the number.
+*'Significance' is the multiple to round the number.
 FLOOR() rounds the number down towards zero, to its nearest multiple of significance.
@@ Line 8: / Line 8: @@
 == Description ==
-FLOOR(number, significance)
+FLOOR(Number, Significance)
 For Example,
@@ Line 17: / Line 17: @@
 *Calci returns an NaN error message if the argument is nonnumeric.
-*Calci returns an #ERROR message if 'number' and 'significance' have different signs.
+*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.