08-14-2020 03:21 AM
How can I do this rounding?
Solved! Go to Solution.
08-14-2020 03:23 AM
Up if equal to 5**
08-14-2020 05:37 AM
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"))
08-14-2020 05:47 AM
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.
08-14-2020 07:40 AM
@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.