Rounding Off to 5 or 10

Hi Vitrag,

You are apparently asking how to round off to the nearest multiple of 5 in excel.

The answer is the below given formula:

=MROUND(CELL NO,5)

Hope you got your answer

Hi..By using Round() functon you can round the value in excel sheet..

  charlotte delivery service

 

I have not found this function in excel.

=mround

This function is available in Excel 2007. If you are using Excel 2003, you may not find it.

Hi Vitraq

In Excel rounding off to nearest 10 can be done by using the formula

=ROUND(<No>,-1)

Thanks Nivedita,

This is very useful to us

Hi vitraq,

You can also round a number in Excel 2003

Just follow the following step

1.Enter the number in a cell

2.divide the number by 5 in another cell

3.put the following formula in another cell to get your answer

4.(=ROUND(G14,0)*5)

5. here G14 is the cell where you divide your number by 5 (in step 2)