I am trying to get a formula to work for a dataset, but I'm having problems. I have the formula set up so that:
But this returns 1 for all columns. What am I doing wrong?
Try a Comma(,) instead of the LessThan(<) symbol in the Random, Integer function.
Alternatively, try not holding down the Shift key when you type the Comma.
Try a comma instead of the less-than symbol between the numbers. The above returns a random integer between 1 and 1 (because 15 is less than 26. Every time)
To enable the optional second argument in the formula editor, select the square within parentheses and click ^.