Help with a formula

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
 
D

Dennis

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top