# Whats the difference between Round Ceiling and Floor Not sure if they exist already in 2007 (usinig 2010), there is now also a ROUNDUP & ROUNDDOWN.

3.FLOORReturns number rounded down, towards zero, to the nearest multiple of significance.

2. CEILINGReturns number rounded up, away from zero, to the nearest multiple of significance.

1.TheROUNDfunction rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:

Significanceis the multiple to which you want to round.

– CEILING rounds always up, eg. 1.61 = 1.7 (=CEILING(A1,0.1)

Significanceis the multiple to which you want to round.

– ROUND rounds down or up, e.g. 1.3 = 1 & 1.5 = 2 (+ROUND(A1,0)

Numberis the value you want to round.

For example, if you want to avoid using pennies in your prices and your product is priced at \$23.78, use the formula =FLOOR(23.78,0.05) to round prices up to the nearest nickel. i.e. it will return 23.75

Whats the difference between Round, Ceiling and Floor

Numberis the value you want to round.

Whats the difference I use round to round the number to amount of digits specified but what doceilingand floor do that is different?

I have the same question 22