1. Computing
Ted French

Excel's FLOOR Function

By January 30, 2013

Follow me on:

The FLOOR function, like the ROUNDDOWN function, can be used to round the last digit of a number downwards.

How they differ is that while ROUNDDOWN only ever rounds that last digit down by one number, the FLOOR function can round down by multiples of the last digit.

Rounding by multiples allows you to set the level of significance for the remaining digits.

To find out all the details, read this short tutorial on Excel's FLOOR Function.

More Rounding Number Functions
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.