Microsoft Excel Functions & Formulas

Use the FLOOR function to round down values

to the nearest 100

As seen in the previous example, 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.

FLOOR(number, significance)

number: The value to be rounded.

significance: The multiple to which the number will be rounded

down.

4

To round down values to multiples of 100:

1. In cells A2:A10 list some prices.

2. Select cells B2:B10 and type the following formula:

=FLOOR(A2,100).

3. Press <Ctrl+Enter>.

164

Chapter 6

Figure 6-19