Difference between revisions of "Manuals/calci/FLOOR"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 1: Line 1:
=FLOOR(Number, Significance)=
+
<div style="font-size:30px">'''FLOOR(Number, Significance)'''</div><br/>
 
 
 
*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.
FLOOR() rounds the number down towards zero, to its nearest multiple of significance.
 
  
 
== Description ==
 
== Description ==

Latest revision as of 16:22, 17 August 2018

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

References