QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Round off Numbers in Excel?

By Neha T Leave a Comment

Excel allows you to round off numbers in case you don’t want to see decimal point values in your Excel cell. With more decimal places in a cell, you could see the ##### symbol which makes the data unpresentable.

Even sometimes you don’t require value accurate up to the microscopic level. But, the round-off numbers in cells are easy to read and are more presentable.

Here, we will be learning about the four different variations of the ROUND formula in Excel.

Steps to Round off Numbers in Excel:

ROUND Function

This function round off the number to a specific number of digits. The syntax of this formula is:

=ROUND(number, num_digits)

Here the number specifies the number that is to be rounded off. And num_digits specify the number of decimal places to round off.

In the image below we have applied the ROUND function on the value 77864.84962. We have specified the value of num_digits from -3 to +3.

round off in excel - 01

Observe the image below:
The negative sign of the rounding digit shows that the number will round off from the left of the decimal point. Such as -3 indicates that the value will be rounded off up to 3 places to the left of the decimal value.

round off in excel - 02

ROUNDUP Function

This function rounds up the number to a specified number of decimal values. The syntax of the ROUNDUP function is:

ROUNDUP(number, num_digit)

Here the number and num_digits specify the same as in the above ROUND function.

  • In the ROUNDUP function also, the positive round-off digit will round up the number to the right of the decimal value.
  • The negative round-off digit will let the excel round up the value to the left of the decimal value.
  • If the round of digits is 0, excel will round up the value to the nearest integer.

roundup in excel - 03

ROUNDDOWN Function

This function round downs the number to the specified number of decimal values. The syntax of the ROUNDDOWN function is:

ROUNDDOWN(number, num_digit)

You can compare the result of the ROUNDDOWN and ROUNDUP functions to understand the difference between these two.

rounddown in excel - 003

 

 

MROUND Function

This function rounds off a number to its specified multiple. The syntax of the MROUND function is:

MROUND (number, multiple)

  1. number: The number that we have to round off.
  2. multiple: It is the multiple to which you want to round off the number.
The MROUND function round off the specified number to the nearest multiple of the specified multiple digits. As you can see in the image below the nearest multiple of 4 around 15 is 16.

MROUNUP function
So, this is how you can use the ROUND function in Excel to round off the numbers in your excel cell.

You Might Also Like:

Calculate Average in Excel feature imageHow to Calculate Average in Excel? generate a random number in excel featured imageHow to Generate Random Number in Excel? Calculate Age in Excel feature imageHow to Calculate Age in Excel? Subtract feature image 1How to Subtract in Excel? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? Calculate percentage Featured ImageHow to Calculate Percentage in MS Excel 2016? Sumif feature imageHow to SUMIF in Excel?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Create a System Restore Point in Windows 10?
  • How to unsubscribe email newsletter in gmail
  • How to Enable Pop-up Blocker in Firefox?
  • How to Stop Uploading Updates to the other PC’s in Windows 10
  • How to Start Windows 7 in Safe Mode

Copyright © 2023 · QueHow · Contact Us