Help with a formula

  • Thread starter Thread starter DCW
  • Start date Start date
D

DCW

I am trying to input a formula like this: Divide the number in A2 by 4 then
multiply that by 5 (A2/4*5) That works fine.

The next thing I want to do is round up any decimal places to the next whole
number. For example if the answer to (A2/4*5) is 11.25 I want it to round
up to 12. Your help would be appreciated.

That is what I need help with.

I am using Office Excel 2007

Thank You,
DCW
 
You have posted this in the Access section instead of the Excel section
Try
=ROUNDUP(A2/4*5,0)
 
Back
Top