Rounding up...

[Joffies]

Hi all.

I would like to round a figure in the following way! Say i have values like $ 1.444 and $1.351 i would like to always round the up the third decimal no matter what! How could i achieve this?

Many thanks.

[phinds]

add .049999 and use the round function to round to 2 places.

[rlwhealdon]

You could use something like:

dblResults = Round(dlbSource + .005, 2)

That would result in:

1.45 = Round(1.444 + .005, 2)
1.36 = Round(1.351 + .005, 2)

but:

1.44 = Round(1.440 + .005, 2)

[Joffies]

Hello again

Is there an easy way to always check how much should be added before i round it mathemetically or is there perhaps another function to use in this case ?

Please advise

[phinds]

both rlwhealdon and I have told you exactly the same thing. Why don't you just try it. you'll see that it works, then you won't have to keep asking quesitons.