How to Round Up to the Nearest 10 in Excel

Description:

How to Round Up to the Nearest 10 in Excel Microsoft Excel is one of the most commonly used tools in the data analyst community. The spreadsheet software allows users to organize large amounts of data, perform complex calculations and automate steps that may take hours into seconds. There are also many commands already programmed into the software such as the formatting or rounding formula. A formula is Excel's way of telling a cell to perform a certain function. Instructions 1. Open your spreadsheet and click on a cell next to the cell(s) you would like to round up to the nearest 10. 2. Input the formula "=MROUND(Cell Reference Number,10)". The Cell Reference Number is the number to round to and 10 is the multiple it will round to. 3. Familiarize yourself with the concept of different formulas using MROUND to make your task easier. The following provide examples of the output for putting the following formulas in a cell. =MROUND(7, 10) Rounds 7 to a nearest multiple of 10 (10) =MROUND(-9, -10) Rounds -9 to a nearest multiple of -10 (-10) =MROUND(18.5, 10) Rounds 18.5 to a nearest multiple of 10 (20) A B C D 1 S.No. Amount Formula Result 2 1 11.12 =MEOUND(B2,10) 10 3 2 15.2 Copy Formula 20 4 3 14 Copy Formula 10 5 4 16 Copy Formula 20 6 5 31 Copy Formula 30 7 6 2552 Copy Formula 2550 Note:- Download this function if it is not available on your toolbar. On the Tools menu, click "Add-ins." Select the "Analysis TookPak" box and click "OK." #doc

Submitted By:

Anil Jha

on 12 May 2012

Other files by the user

Downloaded:

1364 times

File size:

39 KB

Rating:

Download Other files in Info Technology category

Share Report

Comments

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Trending Downloads

CA Final Integrated Business Solutions (Multidisciplinary Case Study with Strategic Management) Question Paper New Course May 2026

On : 13 May 2026
Download

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

RAJ SANKLECHA

Pushkar Nagda

sachingurav

R.Prashanth

SUBASH CHANDRA BOSE

Subscribe Now

How to Round Up to the Nearest 10 in Excel

Trending Downloads

CBDT Central Action Plan 2026-27 Unveiled

CA Final Indirect Tax Laws Question Paper New Course May 2026

CA Final Direct Tax Laws & International Taxation Question Paper New Course May 2026

CA Final Integrated Business Solutions (Multidisciplinary Case Study with Strategic Management) Question Paper New Course May 2026

CA Intermediate Cost & Management Accounting Question Paper New Course May 2026

CA Intermediate Taxation Question Paper New Course May 2026

Trending Online Classes

Meet our CAclubindia PRO Members

Popular Files

Quick Links

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA