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.
7 Replies
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)
Recent Topics
- Returns date of filling gstr1 3b
- GST Portal is Live Now
- ITR for Stamp Duty and Registration Charges for Tr
- RCM on Rent Paid by Composition Dealers
- Development Cess and RCM
- Mistake in challan 26 QC while depositing TDS for
- Query on tax deduction on source
- Need help regarding a non-functioning Private Limi
- RCM on payent of rental charges of commercial prem
- Manufacturing under shops and establishment act?
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
