Setting a value to Random but not to high and not to low?

[Outcast]

I want to set a value in a single event line to a number between -25 and (+)25. But the value should not be in the range of -5 to (+)5.

Right now if I do a set value to Random(50)-25 for example the value I end up with could be for example 3 and that is in the range of -5 to (+)5...

Any idea how to do this?

[DistantJ]

The difficult part is getting it in one event... But I worked it out for you! Use this formula (make sure you include the brackets):

(5+Random(21))*((Random(2)*2)-1)

How it works:

25 + Random(21) = Any number between 5 and 25

Random(2) = Either 0 or 1, so:

0 * 2 = 0
Or
1 * 2 = 2

Subtract 1, so 0 becomes -1 and 2 becomes 1

Meaning we can use that result to multiply it by either -1 or 1 (picked at random).

[Outcast]

The difficult part is getting it in one event... But I worked it out for you! Use this formula (make sure you include the brackets):

(5+Random(46))*((Random(2)*2)-1)

How it works:

25 + Random(26) = Any number between 5 and 50

Random(2) = Either 0 or 1, so:

0 * 2 = 0
Or
1 * 2 = 2

Subtract 1, so 0 becomes -1 and 2 becomes 1

Meaning we can use that result to multiply it by either -1 or 1 (picked at random).

Oh that's a cool solution! Thanks!

[DistantJ]

Pleasure! I like working out math, makes me feel smart... even if it does take me ages

Edited the post because I got some numbers wrong (misread your original post).


Sent from my iPad Mini using Tapatalk HD

[rubes]

that is brilliant, Distant J. thanks for the walk through on the logic

[nim]

Nice solution DistantJ

[foyzul2002]

Great stuff! +10

[DistantJ]

Thanks guys! Fun stuff!


Sent from my iPad Mini using Tapatalk HD