rounding after comma

[hkn10]

How can I do this rounding?

[hkn10]

Up if equal to 5**

[SercoSteveB]

NOTE:  In both examples, Locals.Roundee is the number you want to round.

For your first examples

Round(Locals.Roundee,0)

For your second examples

Val(Str(Locals.Roundee, "%#.1f"))

[SercoSteveB]

Doh! Just seen the "Up if 5" bit on your post.  My examples will "Down if 5".  I think if you want "Up if 5" that will be a pretty complicated statement.

[crossrulz · Accepted solution]

---

@SercoSteveB wrote:

Doh! Just seen the "Up if 5" bit on your post.  My examples will "Down if 5".  I think if you want "Up if 5" that will be a pretty complicated statement.

---

If you use 4 for the Round option, then it will use "banker's rounding" which will round 0.5 to the nearest even integer.  So for the second example use

Locals.Roundee = Round(Locals.Roundee*10,4)/10

To multiply and divide by 10 are to shift the decimal point (or comma) to the left before the round (to round to the nearest 0.1) and to the right to undo the shift after the rounding.