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?
Solved! Go to Solution.
Use a formula tool with expression:
RAND()*2-1
Rand makes a random number between 0 and 1. Then you can double and shift.
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?
Hi,
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)