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