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.
Printable View
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.
add .049999 and use the round function to round to 2 places.
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)
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
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.