writer
2,661
edits
Changes
Manuals/calci/ROUNDUP (view source)
Revision as of 22:22, 27 November 2013
, 22:22, 27 November 2013no edit summary
ROUNDUP() can also be used for multiple number array as -
ROUNDUP() can also be used for multiple number array as -
ROUNDUP(2.55..7.55,1) that rounds the numbers from 2.5 to 6 in steps of 0.5.
ROUNDUP(2.55..7.55,1) that rounds the numbers 2.55 to 6.55 to one decimal place.
{| class="wikitable"
{| class="wikitable"
|-
|-
! Number !! ROUNDUP
! Number !! Num_of_digits !! ROUNDUP
|-
|-
| 2.5 || 3
| 2.55 || 1 || 2.6
|-
|-
| 3 || 3
| 3.55 || 1 || 3.6
|-
|-
| 3.5 || 4
| 4.55 || 1 || 4.6
|-
|-
| 4 || 4
| 5.55 || 1 || 5.6
|-
|-
| 4.5 || 5
| 6.55 || 1 || 6.6
|-
|-
| 5 || 5
| 7.55 || 1 || 7.6
|-
| 5.5 || 6
|-
|-
|}
|}