Use the FLOOR function to round down values to the nearest 100
As seen in our previous article, it is easy to round up values to multiples of 100. To round numbers down to the nearest multiple of significance, use the FLOOR function. Here is the syntax that is used:
FLOOR(number, significance)
number: The value to be rounded.
significance: The multiple to which the number will be rounded down.
To round down values to multiples of 100:
- In cells A2:A10 list some prices.
- Select cells B2:B10 and type the following formula: =FLOOR(A2,100).
- Press Ctrl+Enter.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- How to Use the CEILING function to round up values to the nearest 100
- Use the MROUND function to round values to the nearest multiple of 10 or 50
- How to Round Time to the nearest 15 minute in Excel
- How to Use the MROUND function to round prices to 5 or 25 cents
- How to Use the ROUND function to round time values to whole minutes
