MROUND Function (Functions in Excel)
Number | Multiple | Rounded Value | |
110 | 50 | 100 | =MROUND(C4,D4) |
120 | 50 | 100 | =MROUND(C5,D5) |
150 | 50 | 150 | =MROUND(C6,D6) |
160 | 50 | 150 | =MROUND(C7,D7) |
170 | 50 | 150 | =MROUND(C8,D8) |
What Does It Do ? |
This function rounds a number up or down to the nearest multiple specified by the user. |
Syntax |
=MROUND(NumberToRound,MultipleToUse) |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment