How to Use Excel FLOOR Function in Office 365? – (With Examples)
Tags: excelfloorfunctionin, excelfunctions
Published: 2020-08-21 16:56:32

---
title: How to Use Excel FLOOR Function in Office 365? – (With Examples)
published: true
date: 2020-08-20 11:39:36 UTC
tags: ExcelFLOORFunctionin,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/
---

## FLOOR Function in Excel:

Here, we are going to learn the usage of **Excel FLOOR Function in Office 365** with its basic syntax, explanation, and examples. 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)

 

## Floor Function – Explanation:

- This function **rounds a number down to the nearest multiple of significance**.
- In FLOOR Function we will use two numbers (arguments) such as **input value** and **significance value**.
- The Significance value used to round the input value.
- For example, if you give the **FLOOR(23, 4)**, it returns the output as **20**.

## Basic Syntax:

=**FLOOR(number, significance)**

### Argument Definition:

**Number** – The input value that you want to round.

**Significance** – The multiple which is used to round the given number.

### Note:

- If either a number or significance is non-numeric (letters, symbols), it returns the **#VALUE!** Error.
- When you use a **positive input number** and **negative significant number** , it shows **#NUM!** Error value.
- If the number is an exact multiple of significance, no rounding occurs.

## Examples:

Let’s see some examples to understand how **FLOOR Function** works.

### Example 1:

- In the below image, you can see the **input** value in the **Cell A3** and its **significance** value in **B3 Cell**.
- The value **50** is rounded using the significance value **7** and returns the output as **49** Because it is the nearest multiple of the given input number.

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

### Example 2:

- If either a number or significance is non-numeric (letters, symbols), it returns the **#VALUE!** Error.

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

### Example 3:

- When you use a **positive input number** and **negative significant number** , it shows **#NUM!** Error value.

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

## Sum-Up:

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

### Similar Functions:

- [**FLOOR.MATH Function in Excel 365**](https://geekexcel.com/how-to-use-excel-floor-math-function-in-office-365/)
- [**FLOOR.PRECISE Function in Excel 365 **](https://geekexcel.com/how-to-use-excel-floor-precise-function-in-office-365/)

### See Also:

- [How to use Excel MONTH Function in Office 365?](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)
- [How to Use Excel SHEETS Function in Office 365? – [With Examples]](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/)