FLOOR function in Excel

Syntax

=FLOOR(number, significance)

Example

=CEILING(47,15) returns 60. =FLOOR(62,12) returns 60.

From the lesson FLOOR & CEILING Functions.

Common mistakes

• Confusing the multiple (significance) with the number of decimals used by ROUND.
• Using FLOOR when you need to round up for billing.

Related math functions

• SUMAdds all the numbers in a range.
• SUMIFAdds the cells that meet one condition.
• SUMIFSAdds the cells that meet several conditions.
• SUMPRODUCTMultiplies matching items and returns the sum of those products.
• ROUNDRounds a number to a given number of digits.
• ROUNDUPRounds a number up, away from zero.
• ROUNDDOWNRounds a number down, toward zero.
• CEILINGRounds up to the nearest multiple of significance.