Generate random sign for integer

[JulianMS]

I'm generating a random number between 5 and 10:

RRandom(5, 10)

But I want to randomly assign it a positive or negative value. Basically I'm trying to generate a random number between -10 and 10 but excluding -4 to 4

[casleziro]

randomly multiply the result by -1?

If that doesn't work for you, populate a string with all of your numbers seperated by a delimiter, like this:

"-10, -9, -8, -7, -6, -5, 5, 6, 7, 8, 9, 10"

Then use the string tokenizer extension to split the string and retrieve a random element out of the 12: randomexample1.mfa

EDIT: I forgot to, but instead of specifying Random(11), you can set it to Random(ElementCount("String Tokenizer")) to have it manually choose out of all elements.

[JulianMS]

Thanks for the help casleziro

I managed to solve it using this:

RRandom(5,10) * Val(Left$("--", Random(2)) + "1")

It randomly puts either one or two "minus" signs in front of the "1" making it positive or negative. Kind of weird solution but it works :P

[casleziro]

Nice job. It's simpler than my solution at least.