| Be My Friend

Round Function in Excel

Round Function | Round Syntax | Round Examples | Roundup Function | Rounddown Function

In this tutorial, we are going to discuss three functions to round numbers in Excel. ROUND, ROUNDUP, and ROUNDDOWN with examples.

ROUND Function

The ROUND function in Excel returns a number rounded to a specified number of digits. with this ROUND function, we can do rounds up or down.

Syntax

=ROUND(number, num_digits)

=ROUNDUP(number, num_digits)

=ROUNDDOWN(number, num_digits)

Arguments Explained:

  • number -The number that you want to round (Required).
  • num_digits - The number of digits to which you want to round the number argument(Required).

Round Function Examples

1. Round a number to one decimal.

In the below example, the amount 12323.51768 is showing as 12323.5 after applying Round formula on cell B2.

Round Function in Excel

2. Round a number to two decimal.

In the below example, the amount 12323.51768 is showing as 12323.52 after applying Round formula on cell B2.

Round to Two Deciamals

Similarly, you can also Round a number to three decimal places.

If you want to

  • Round to the nearest 10 use -1
  • Round to nearest 100 use -2
  • Round to nearest 1000 use -3, etc.

Result is

Excel ROUND Function

ROUNDUP Function in Excel

The Excel ROUNDUP function always rounds a number up. ROUNDUP behaves like ROUND, except that it always rounds a number up.

ROUNDUP Function Example:

ROUNDUP Function in Excel

ROUNDDOWN Function in Excel

The Excel ROUNDDOWN function always rounds a number down. it always rounds a number down towards zero.

ROUNDDOWN Function Example:

ROUNDDOWN Function in Excel

You May Also Like the Following Excel Tutorials:

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

Download the sample Round Function in Excel file for free.

To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments




Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials