ROUNDUP to 9s

[Guest]

How do you ROUNDUP to 9s?

..94 to .99
1.08 to 1.09
2.41 to 2.49

Like you would in excell
=ROUNDUP(A1+0.01,1)-0.01

 

[Gary Walter]

Hi Kevin,

Here might be a couple of ways:

-- A1 is always positive (can be Null)

int(float*10)/10 +.09

-- A1 is always non-null, positive or negative:

Fix(A1*10)/10 + (Sgn(A1)*.09)

--

IIF(A1 IS NULL, NULL,
Fix(A1*10)/10 + (Sgn(A1)*.09))

good luck,

gary

 

[Guest]

Thanks for your help on this one.

Also, how do you ROUNDUP to 10ths (2 decimals)?

..943 to .95
1.081 to 1.09
2.417 to 2.42

Like you would in excell
=ROUNDUP(A1,2)

 

[John Spencer]

Assuming all numbers are positive, you should be able to use something like

-Int(-[YourNumber]*100)/100

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

 

[Guest]

Thanks!

Assuming all numbers are positive, you should be able to use something like

-Int(-[YourNumber]*100)/100

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