Difference between revisions of "Manuals/calci/FLOOR"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
For Example, | For Example, | ||
| + | |||
FLOOR (3.5, 2) ''returns 2''. | FLOOR (3.5, 2) ''returns 2''. | ||
| Line 34: | Line 35: | ||
| class=" " | '''Output''' | | class=" " | '''Output''' | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" |FLOOR( | + | | class="sshl_f" |FLOOR(55.55,5) |
| − | | class="sshl_f" | | + | | class="sshl_f" |55 |
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" |FLOOR | + | | class="sshl_f" |FLOOR(1000.34,3) |
| − | | class="sshl_f" | | + | | class="sshl_f" |999 |
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" |FLOOR | + | | class="sshl_f" |FLOOR(22.3) |
| − | | class="sshl_f" | | + | | class="sshl_f" |22 |
| − | |- class=" | + | |- class="even" |
| − | | class="sshl_f" |FLOOR | + | | class="sshl_f" |FLOOR(-143.56,-1) |
| − | | class="sshl_f" | | + | | class="sshl_f" |-143 |
|} | |} | ||
Revision as of 16:28, 2 December 2013
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.