Round up on .1?

[Round up on .01]

Trying to use access to generate a price list. Having a hard time getting
access to round the same way as the system we have. Been using E2 Roll:
(Round(((((([5.13])/0.8)/9))),2))*9, which comes out with 6.39. When you
divide by 9 you get .7125, need to have it round up on .01. Any help would
be apreciated.

 

[John Spencer]

If you mean you want it to round up to the next whole penny, then try the
following.

-Int(-[YourNumberHere] / .01) * .01



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Round up on .01]

Need to keep the answer divisable by .09. The computer comes up with 6.48,
and my formula comes up 6.39.

If you mean you want it to round up to the next whole penny, then try the
following.

-Int(-[YourNumberHere] / .01) * .01



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Trying to use access to generate a price list. Having a hard time getting
access to round the same way as the system we have. Been using E2 Roll:
(Round(((((([5.13])/0.8)/9))),2))*9, which comes out with 6.39. When you
divide by 9 you get .7125, need to have it round up on .01. Any help would
be apreciated.

 

[John Spencer]

Int(-5.13/0.8/9 / .09) * .09 will return .72
9 * .72 = 6.48

or if you want the total of 6.48 try

-Int(-5.13/0.8/.09) * .09 will return 6.48

None of this is fully tested, but I think it will give you what you want.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Need to keep the answer divisable by .09. The computer comes up with 6.48,
and my formula comes up 6.39.

If you mean you want it to round up to the next whole penny, then try the
following.

-Int(-[YourNumberHere] / .01) * .01



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Trying to use access to generate a price list. Having a hard time getting
access to round the same way as the system we have. Been using E2 Roll:
(Round(((((([5.13])/0.8)/9))),2))*9, which comes out with 6.39. When you
divide by 9 you get .7125, need to have it round up on .01. Any help would
be apreciated.