1. Computing
Ted French

Round Numbers Down in Excel

By January 28, 2013

Follow me on:

The ROUNDDOWN function in Excel is similar to the ROUND function in that it is often used to reduce the number of decimal places of data. How it differs is that it always rounds the last digit down to the lower number.

One thing to note is that unlike formatting options that allow you change the number of decimal places displayed, the ROUNDDOWN function actual alters the data in your worksheet and can, therefore, affect calculations.

To find out how to use this function, read the short tutorial on the Excel ROUNDDOWN Function.

Related Tutorials

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.