Roundup formula question

  • Thread starter Thread starter Ed S
  • Start date Start date
E

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
 
Something like this:

=ROUNDUP(your_formula,0)

will round up to an integer.

Hope this helps.

Pete
 
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
 
Back
Top