round figures to nearest 500 in Excel

Q29. Is there a way I can round the sales figure to the nearest 500?

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.

excel round figures to nearest 500

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) I want to force a page break at a certain row - how can I do that?

2) How can I enter information in multiple cells simultaneously?

3) Conditional formatting with if statement in Excel

4) Split one long column into multiple smaller columns in Excel

5) Keyboard shortcut for save as in Excel

6) How to change the color of gridlines in a worksheet in Excel

7) Sumifs with date range as criteria in Excel

8) Formula does not calculate in Excel

9) I have test scores for my student population. In Excel, how can I determine confidence interval for my Population Mean?

10) Formula does not calculate in Excel

11) Is there a way I can average a range of numbers even if there is an error value in range?

12) How can I set up a drop down list?

13) Subtotal and sumif combination help in Excel

14) How can I shade alternate rows in color using VBA to make it easier to read voluminous data running into hundreds of rows?

15) How can I have text autocomplete by typing in a short code for the text?