1. Computing
Ted French

Round Numbers Down with the FLOOR Function

By February 19, 2012

Follow me on:

The FLOOR function in Excel is similar to the ROUNDDOWN Function in that they both round the last digit downwards.

How they differs is that while the ROUNDDOWN function only ever rounds that last digit down by one number, the FLOOR function can round up 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 on using this function, 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.