How should i round off a number nearest to 5 or 10.
For example, if I write 542, it should be converted into 540 and If I write 546, it should be converted into 545.
CA Vitrag S Modi (Chartered Accountant) (186 Points)
25 June 2010How should i round off a number nearest to 5 or 10.
For example, if I write 542, it should be converted into 540 and If I write 546, it should be converted into 545.
Vandana Gupte
(Service)
(35 Points)
Replied 26 June 2010
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
Royle Lindsey
(seo)
(22 Points)
Replied 28 June 2010
Hi..By using Round() functon you can round the value in excel sheet..
Ajay Raghatate
(Sr Executive (Excise & Accounts))
(736 Points)
Replied 06 July 2010
I have not found this function in excel.
=mround
Vandana Gupte
(Service)
(35 Points)
Replied 06 July 2010
This function is available in Excel 2007. If you are using Excel 2003, you may not find it.
Nivedhitha Srinivasan
(Articled Assistant)
(28 Points)
Replied 12 July 2010
Hi Vitraq
In Excel rounding off to nearest 10 can be done by using the formula
=ROUND(<No>,-1)
Ajay Raghatate
(Sr Executive (Excise & Accounts))
(736 Points)
Replied 13 July 2010
Thanks Nivedita,
This is very useful to us
CA Prateek Garg
(CA in Practice)
(1447 Points)
Replied 24 July 2010
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)
CAclubindia
