Exceljet

Quick, clean, and to the point

Excel FLOOR Function

Excel FLOOR function
Summary 

The Excel FLOOR function rounds a given number down to the nearest specified multiple. FLOOR works like the MROUND function, but FLOOR always rounds down.

Purpose 
Round a number down to the nearest specified multiple
Return value 
A rounded number.
Syntax 
=FLOOR (number, multiple)
Arguments 
  • number - The number that should be rounded.
  • multiple - The multiple to use when rounding.
Usage notes 
  • FLOOR works like the MROUND function, but FLOOR always rounds down.
  • With a positive number, the value is rounded down toward zero.
  • With a negative number, the value is rounded down away from zero.
  • The FLOOR function can be a good way to can be a good way to set pricing after currency conversion, discounts, etc.

Excel Formula Training

Formulas are the key to getting work done in Excel. In this step-by-step training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Start building valuable skills with Excel formulas today. Learn more.

There is a lot of excel reference on the web but I liked yours the best so far: very clear, very easy to follow, very practical and visually attractive. Amazingly, that you give away so much for free, but it works in terms that I am your fan now and will be recommending your site at any opportunity I have. -Irena
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course