Round figures to nearest 500 in Excel
For example, for ease of review, I am interested in rounding the $ values to nearest 500.
To do it in Excel, here is the answer:
a) Enter the formula =MROUND(F2,500) where F2 corresponds to sales figure.
b) There are 2 other options -
i) For rounding down, enter the formula =FLOOR(F2,500) where F2 corresponds to sales figure.
ii) For rounding up, enter the formula =CEILING(F2,500) where F2 corresponds to sales figure.
You can find similar Excel Questions and Answer hereunder
1) What are the date and time function in Excel VBA
2) How can I see where page breaks occur before actually printing?
3) Keyboard shortcut for save as in Excel
4) How can i filter multiple columns simultaneously in Excel
5) In Excel we use forms to interface with the user. Here some basics about GUI or graphical user interface
6) How to use goal seek in Excel. Some good introduction to goal seeking function
7) How to change the color of gridlines in a worksheet in Excel
8) How to concatenate strings in vba in Excel
9) How can I calculate depreciation of assets using Excel?
10) How to protect your worksheet from changes in Excel