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

Did this solve your problemYesNo

Did this solve your problemYesNo

Tell us about your experience with our site

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

– FLOOR rounds always down, e.g. 1.61 = 1.6 (=FLOOR(A1,0.1)