Hi,
I am wondering how to generate a random number between negative and positive one.
I've found out how to generate a number between 0 and 1. But in terms of a negative number I've had no luck.
Any advice?
Use a formula tool with expression:
RAND()*2-1
Rand makes a random number between 0 and 1. Then you can double and shift.
If you only want to show these values: -1, 0 and 1. You can use the following formula:
SWITCH(RandInt(2),1,0,-1,1,0,2,1)
I have decided to use two random Values, the second random value will decide whether the first random value is positive or negative (first random value is between 0 and 1).
Any better solutions?
