writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 2:
Line 2: − + Line 62:
Line 62: − |+ − |+ − |+ − |+ − |+ − + + + +
no edit summary
*Where 'number' is the number to round and
*Where 'number' is the number to round and
*'num_of_digits' is the number of digits before or after decimal point.
*'num_of_digits' is the number of digits to which the number is to be rounded.
ROUND() rounds a number to specified number of digits.
ROUND() rounds a number to specified number of digits.
| class=" " | '''Function'''
| class=" " | '''Function'''
| class=" " | '''Output'''
| class=" " | '''Output'''
|- class="odd"
|- class="odd"
| class="sshl_f" | ROUND(3.6712,2)
| class="sshl_f" | ROUND(3.6712,2)
| class="sshl_f" | 3.67
| class="sshl_f" | 3.67
|- class="even"
|- class="even"
| class="sshl_f" | ROUND(99.37,0)
| class="sshl_f" | ROUND(99.37,0)
| class="sshl_f" | 99
| class="sshl_f" | 99
|- class="odd"
|- class="odd"
| class="sshl_f" | ROUND(99.37)
| class="sshl_f" | ROUND(99.37)
| class="sshl_f" | 99
| class="sshl_f" | 99
|- class="even"
|- class="even"
| class="sshl_f" | ROUND(145.8,-1)
| class="sshl_f" | ROUND(145.8,-1)
| class="sshl_f" | 150
| class="sshl_f" | 150
|- class="odd"
|- class="odd"
| class="sshl_f" | ROUND(-89.65,1)
| class="sshl_f" | ROUND(-89.65,1)
| class="sshl_f" | -89.7
| class="sshl_f" | -89.7
|
|- class="odd"
| class="sshl_f" | ROUND(-89.65,-1)
| class="sshl_f" | -90
|}
|}