Understand FLOOR Function in Excel with Example

Understand FLOOR Function in Excel with Example


It is an enhance version of ROUND function but doesn’t mind decimal places in Excel. Floor function will round a number down side to its nearest or closest multiple of significance. Consider below example where we will apply Floor formula and try to round values by 100 and 10 respectively.


=FLOOR(number, significance)

  1. Number: refers to any cell value that you wold like to round.
  2. Significance: refers to the value upto you want your round in place



Please leave your comments or queries under comment section also please do subscribe to our blogs to keep your self upto date.

Leave a Reply

Your email address will not be published. Required fields are marked *