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) | + | FLOOR (3.5, 2) ''returns 2''. |
| − | *Calci returns an error value | + | *Calci returns an error value 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 the number is an exact multiple of significance, rounding will not be done. Calci will display the same number as output. | ||
| Line 23: | Line 23: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | | class=" " | '''Function''' | |
| − | + | | class=" " | '''Output''' | |
| − | |||
| − | |||
| − | | class=" " | | ||
| − | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" |FLOOR(1000.34) |
| − | |||
| − | |||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |FLOOR | |
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |FLOOR | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |FLOOR | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/CEILING | CEILING]] | ||
| + | |||
| + | *[[Manuals/calci/INT| INT]] | ||
| + | |||
| + | *[[Manuals/calci/ROUND | ROUND]] | ||
| + | |||
| + | *[[Manuals/calci/ROUNDUP | ROUNDUP]] | ||
| + | |||
| + | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]] | ||
| + | |||
| + | *[[Manuals/calci/TRUNC| TRUNC]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Rounding#Tie-breaking Rounding] | ||
| + | *[http://http://en.wikipedia.org/wiki/Floor_and_ceiling_functions FLOOR Function] | ||
Revision as of 15:07, 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.
- Calci returns an error value 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.