How to ROUND Values Using Functions in Excel Office 365?
Tags: excelpreface, roundingfunctionsine
Published: 2020-09-08 06:36:56

---
title: How to ROUND Values Using Functions in Excel Office 365?
published: true
date: 2020-09-07 12:18:26 UTC
tags: ExcelPreface,ROUNDINGFunctionsinE
canonical_url: https://geekexcel.com/how-to-round-values-using-functions-in-excel-office-365/
---

## ROUNDING Values Using Functions in Excel:

In this article, we are going to learn the different types of **ROUNDING Values Using Functions in Excel Office 365**. Let’s get 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)

## **Rounding Function – Description:**

- The **ROUNDING** Function used to round the given integer to the nearest integer value.
- If the number is less than 0, it will round to the left of the decimal point. If the number is away from zero, use the [**ROUNDUP**  **function**](https://geekexcel.com/how-to-use-excel-roundup-function-in-office-365/).

## **Types of Rounding Functions in Excel:**

### ROUND Function:

- This function is used to round a number to the specified number of digits.

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

For more information, Kindly refer to the**[ROUND Function](https://geekexcel.com/how-to-use-excel-round-function-in-office-365-with-examples/)**.

### ROUNDUP Function:

- This function rounds a number up to the specified number of decimal places.

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

For more information, Kindly refer to the **[ROUNDUP Function](https://geekexcel.com/how-to-use-excel-roundup-function-in-office-365/).**

### ROUNDDOWN Function:

- This function returns a number rounded down to the specified number of decimal places.

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

For more information, Kindly refer to the[**ROUNDDOWN Function.**](https://geekexcel.com/how-to-use-excel-rounddown-function-in-office-365/)

### FLOOR Function:

- This function is used to round a number down to the nearest specified multiple.

=**FLOOR(number, significance)**

For more information, Kindly refer to the **[FLOOR Function](https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/).**

### MROUND Function:

- This function will round a number up or down to a given instance.

**=MROUND(number, significance)**

For more information, Kindly refer to the **[MROUND Function](https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/).**

### CEILING Function:

- This function rounds a number up to the nearest specified multiple.

**=CEILING(number, significance)**

For more information, Kindly refer to the **[CEILING Function](https://geekexcel.com/how-to-use-excel-ceiling-function-in-office-365-with-examples/).**

### INT Function:

- This function rounds a number down to the nearest specified number.

**=INT(number)**

For more information, Kindly refer to the **[INT Function](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/).**

### TRUNC Function:

- This function returns the truncated value based on the specified number of digits.

**=TRUNC(number, [num\_digits])**

For more information, Kindly refer to the **[TRUNC Function](https://geekexcel.com/how-to-use-excel-trunc-function-in-office-365-with-examples/).**

## **End of the Article:**

In this article, you can understand the various kind of **ROUNDING Functions in Excel Office 365**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [Excel Logical Functions in Office 365!! [Simple Guide]](https://geekexcel.com/logical-functions-in-microsoft-excel-365-simple-guide/)
- [List of Excel ‘Information Functions’ in Office 365!!](https://geekexcel.com/list-of-excel-information-functions-in-office-365/)