How to use the FLOOR function
Author: Oscar Cronquist Article last updated on May 04, 2022
The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance.
1. FLOOR Function Syntax
FLOOR(number, significance)
2. FLOOR Function Arguments
number | Required. The number you want to round. |
significance | Required. The multiple to which you want to round. |
3. FLOOR Function Example
Formula in cell C3:
=FLOOR(B3, 2)
Functions in 'Compatibility' category
The FLOOR function function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form