Roundup formula question

[Ed S]

I am trying to roundup a cell that already has a formula in it...

R2 SO

167 =OR/12*2 (The result is 27.8)

OR is 12 months of sales figures and SO is 2 months. How do I get 2 months of sales figures rounded up to the nearest number?



Thanks in advance
Ed

 

[Pete_UK]

Something like this:

=ROUNDUP(your_formula,0)

will round up to an integer.

Hope this helps.

Pete

 

[Ed S]

Thank you Pete. I thought I had tried that but I guess I didn't.

Something like this:

=ROUNDUP(your_formula,0)

will round up to an integer.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Ed - thanks for feeding back.

Pete