Round up on .1?

  • Thread starter Thread starter Round up on .01
  • Start date Start date
R

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.
 
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
 
Need to keep the answer divisable by .09. The computer comes up with 6.48,
and my formula comes up 6.39.

John Spencer said:
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.
Click to expand...
Click to expand...
 
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.

John Spencer said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top