Microsoft Excel Functions & Formulas

Use the ROUNDDOWN function to round

numbers down

To cut off numbers to a specific decimal place or round numbers

down in a worksheet, use the ROUNDDOWN function. This func-

tion rounds a number down, toward zero.

ROUNDDOWN(number, num_digits)

number: Any real number to be rounded down.

num_digits: The number of digits number will be rounded down

to. If greater than 0, number is rounded to num_digits decimal

places. If 0, number is rounded to the nearest integer. If less

than 0, number is rounded to the left of the decimal point.

4

To round down numbers:

1. In cells A2:A10 enter numbers with a decimal point.

2. Enter in cells B2:B10 the number of decimal places ...