• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

How to round a number off to the nearest multiple in Excel

By admin on June 2, 2017April 19, 2019

If you need to round a number off to a specified multiple, for example; rounding a selling price to the nearest 5cents or rounding a time to the nearest 15 minutes—then MROUND is the function to use. Below we explain how that can be done.
Applies To: Microsoft® Excel® for Windows 2010,2013,2016
If you want to calculate what your selling price should be after adding a markup of 15%, you might want to round the price off to the nearest 5 cents.

With the MROUND function, the first argument, “number” refers to the cell containing the value to be rounded and the “multiple” is the value to use when rounding.
You can also use the MROUND function to round time to a specified increment. For example, you might need to round the time to the nearest 15 minutes.

When using the MROUND function, both arguments in the function must have the same sign, i.e. both either positive or negative.  If you have a table containing both positive and negative numbers, then you will need to multiply the second argument by the sign of the first argument using the SIGN function.
In the below example, the SIGN function returns a 1 if the sign is positive and -1 if the sign is negative.

By rounding these digits off, it is easier to describe and understand them. Calculations are also simplified this way, hence spending less time on formulas.
The post How to round a number off to the nearest multiple in Excel appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Create your own Operational Report in Sage Intelligence Reporting Cloud
How to quickly convert negative values to positive values

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd