writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 49:
Line 49: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Manuals/calci/ROUNDUP (view source)
Revision as of 22:25, 27 November 2013
, 22:25, 27 November 2013no edit summary
*ROUNDDOWN() can be used to round a number towards zero.
*ROUNDDOWN() can be used to round a number towards zero.
*MROUND() can be used to round a number to desired multiple.
*MROUND() can be used to round a number to desired multiple.
== Examples ==
<div id="6SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " | '''Function'''
| class=" " | '''Output'''
|- class="odd"
| class="sshl_f" | ROUND(3.6712,2)
| class="sshl_f" | 3.67
|- class="even"
| class="sshl_f" | ROUND(99.37,0)
| class="sshl_f" | 99
|- class="odd"
| class="sshl_f" | ROUND(99.37)
| class="sshl_f" | 99
|- class="even"
| class="sshl_f" | ROUND(145.8,-1)
| class="sshl_f" | 150
|- class="odd"
| class="sshl_f" | ROUND(-89.65,1)
| class="sshl_f" | -89.7
|- class="odd"
| class="sshl_f" | ROUND(-89.65,-1)
| class="sshl_f" | -90
|}
== See Also ==
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]]
*[[Manuals/calci/ROUND | ROUND]]
*[[Manuals/calci/MROUND | MROUND]]
*[[Manuals/calci/INT | INT]]
*[[Manuals/calci/TRUNC | TRUNC]]
*[[Manuals/calci/CEILING | CEILING]]
*[[Manuals/calci/FLOOR | FLOOR]]
==References==
*[http://en.wikipedia.org/wiki/Rounding Round Function]