ROUNDUP Function (Functions in Excel)
Number | Places To Round | Rounded Up | |
1.47589 | 0 | 2 | =ROUNDUP(C4,D4) |
1.47589 | 1 | 1.5 | =ROUNDUP(C5,D5) |
1.47589 | 2 | 1.48 | =ROUNDUP(C6,D6) |
13643.48 | -1 | 13650 | =ROUNDUP(C7,D7) |
13643.48 | -2 | 13700 | =ROUNDUP(C8,D8) |
13643.48 | -3 | 14000 | =ROUNDUP(C9,D9) |
What Does It Do ? |
This function rounds a number up to a specified amount of decimal places. |
If 0 is used the number is rounded up to the nearest whole number. |
If a negative amount of rounding is used the figures to the left of the decimal point are rounded. |
Syntax |
=ROUNDUPNumberToRound,DecimalPlacesToUse) |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment