Difference between revisions of "Manuals/calci/FLOOR"
Jump to navigation
Jump to search
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =FLOOR( | + | <div style="font-size:30px">'''FLOOR(Number, Significance)'''</div><br/> |
| − | + | *Where 'Number' is the numeric value to round and | |
| − | *Where ' | + | *'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 == | ||
| − | FLOOR( | + | FLOOR(Number, Significance) |
For Example, | For Example, | ||
| Line 17: | Line 15: | ||
*Calci returns an NaN error message if the argument is nonnumeric. | *Calci returns an NaN error message if the argument is nonnumeric. | ||
| − | *Calci returns an #ERROR message if ' | + | *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 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. | *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- | *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. | + | 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. <br>''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. | + | b) 2.5..4.5|FLOOR(x+2,2)| where x varies from 2.5 to 4.5 , <br>adds value 2 and displays output to multiples of 2. ''Displays 4,4,6'' as output. |
== Examples == | == Examples == | ||
| Line 47: | Line 45: | ||
| class="sshl_f" |-143 | | class="sshl_f" |-143 | ||
|} | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|mJaqx05SOlM|280|center|FLOOR AND CEILING}} | ||
== See Also == | == See Also == | ||
| Line 66: | Line 68: | ||
*[http://en.wikipedia.org/wiki/Rounding#Tie-breaking Rounding] | *[http://en.wikipedia.org/wiki/Rounding#Tie-breaking Rounding] | ||
*[http://http://en.wikipedia.org/wiki/Floor_and_ceiling_functions FLOOR Function] | *[http://http://en.wikipedia.org/wiki/Floor_and_ceiling_functions FLOOR Function] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
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
See Also
References