Hey all, been trying to solve a problem involving random values, and have had a good search through the manual and forums but can't seem to figure this out...
I'm trying to pick a random value between 1 and 3, and are currently using this which works fine (the 'Ceil' rounds the numbers up to whole decimals, which is what i want):
Ceil(Random(3))
But how do I use this to pick only 1 or 3 (i need to exclude 2). I thought it would be something like this, but it doesn't work:
Ceil(Random(1,3))
Thinking it would choose either 1 or 3...I think I'm barking up the wrong tree with this logic.
Does anyone know a way to do this? Totally appreciate the help...