Rounding Off to 5 or 10

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.

Replies (7)

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)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details