**Tom’s Tutorials For Excel: Rounding Numbers By Fractions or Decimals**

When rounding numbers to a particular decimal factor, you can express that rounding factor in your formula as either a fraction or as its decimal equivalent. In the pictures, the fraction one-eighth can be stated in a formula as 1/8 or by its decimal equivalent of .125.

__Rounding up__

Expressing a fraction, the formula in cell B4 copied to cell B8 is `=CEILING(A4,1/8)`

Expressing a decimal, the formula in cell D4 copied to cell D8 is `=CEILING(A4,0.125)`

Notice the results in range B4:B8 are the same as the results in range D4:D8.

__Rounding down__

Expressing a fraction, the formula in cell C4 copied to cell C8 is `=FLOOR(A4,1/8)`

Expressing a decimal, the formula in cell E4 copied to cell E8 is `=FLOOR(A4,0.125)`

Notice the results in range C4:C8 are the same as the results in range E4:E8.