ROUND Function (Functions in Excel)
Number | Places To Round | Rounded Number | |
1.47589 | 0 | 1 | =ROUND(C4,D4) |
1.47589 | 1 | 1.5 | =ROUND(C5,D5) |
1.47589 | 2 | 1.48 | =ROUND(C6,D6) |
13643.47589 | -1 | 13640 | =ROUND(C7,D7) |
13643.47589 | -2 | 13600 | =ROUND(C8,D8) |
13643.47589 | -3 | 14000 | =ROUND(C9,D9) |
What Does It Do ? |
This function rounds a number to a specified amount od decimal places. |
If 0 is used the number is rounded 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 |
=ROUND(NumberToRound,DecimalPlacesToUse) |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment