Roundup a cell with a formula

[bamroll]

I have a formula in a cell, =C1/12 that is giving me a number as 20.8325. I want to round this # up in the same cell to the next whole # 21. Can I modify the =C1/12 to roundup in the same cell?
Thanks, Bob

[jasoncw]

Sure. If you always want to round the number up, you can use:

=ROUNDUP(C1/12,0)

But if you want to round to the nearest whole number, use:

=ROUND(C1/12,0)

HTH

Jason