Difference between revisions of "Manuals/calci/FLOOR"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | =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) is 2 | ||
| − | + | *Calci returns an error value when 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. | |
| − | |||
| − | |||
| − | + | == Examples == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="6SpaceContent" class="zcontent" align="left"> | <div id="6SpaceContent" class="zcontent" align="left"> | ||
| Line 114: | Line 68: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 07:00, 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) is 2
- Calci returns an error value when 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.
Examples
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3.5 | 2 | ||
| Row2 | 2 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |