How to Use Excel ROUND Function in Office 365? – (with Examples)
Tags: excelfunctions, excelroundfunctionin
Published: 2020-08-27 11:01:44

---
title: How to Use Excel ROUND Function in Office 365? – (with Examples)
published: true
date: 2020-08-27 07:09:54 UTC
tags: ExcelFunctions,ExcelROUNDFunctionin
canonical_url: https://geekexcel.com/how-to-use-excel-round-function-in-office-365-with-examples/
---

## Excel ROUND Function:

![ROUND Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/ROUND-Function.png)<figcaption id="caption-attachment-12679">ROUND Function</figcaption>

In this article, we are going to see how to use **Excel ROUND Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **ROUND Function – Explanation:**

- This function **rounds a number to the specified number of digits**.
- For example, **ROUND(3.18302, 2)** returns the output value as **3.18**

## **Syntax:**

**=ROUND(number, num\_digits)**

### Argument Explanation:

**Number ** – The input number that needs to be rounded.

**Num\_digits ** – The number of digits by which you want to round the given number.

- If num\_digits is **greater than 0** , It will round the number to the specified number of decimal places.
- It will round the number to the nearest integer if **num\_digits is 0**.
- If **num\_digits is less than 0** and then it will round the number to the left of the decimal point.
- If the floating-point value is **greater than or equal to 5** and then this ROUND function will **add number 1** to the decimal value and print the rounded output. For example, **ROUND(14567.89, -3)** will return the value **15000**.

![ROUND Function working explanation](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Screenshot_2.png)<figcaption id="caption-attachment-12713">ROUND Function working explanation</figcaption>

### Note:

- If any argument is a non-numeric value such as letters, special characters and then it will return **#VALUE!** Error.

## **Examples:**

Let’s see some examples to make it clear.

### Example 1:

- Refer to the below example.
- Here, you can see the input numbers in **Column A** , its specified digits in **Column B**.
- The rounded output values are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-81.png)<figcaption id="caption-attachment-12676">Example 1</figcaption>

### Example 2:

- If any argument is a non-numeric value such as letters, special characters and then it will return **#VALUE!** Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-66.png)<figcaption id="caption-attachment-12677">Example 2</figcaption>

## **Closure:**

In the above article, you can clearly understand the usage of **Excel ROUND Function in Office 365** with its syntax, explanation, and examples. Drop your **queries/suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- [**MROUND Function**](https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/)
- [**CEILING Function**](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/)
- **ROUNDUP Function**
- **ROUND DOWN Function**

### Read Also:

- [How to Use “Excel RAND Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-rand-function-in-office-365-with-examples/)
- [How to Use Excel LOG Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-log-function-in-office-365-with-examples/)