I am trying to create a spreadsheet and at some point I need a cell to point to another cell with a list of variants, so as to have a random outcome (random variables 1 to 10)
How shall your “another cell” list the “variants”?. The standard should be that you make a selection from an array of “variants” given in a cell range with the help of the INDEX() function e.g.
Trying to use something like a semicolon separated list you will face a lot of problems due to the fact that LibO (like other spreadsheets) doesn’t offer a TEXTSPLIT() function.
Place your 10 items in cells A1:A10 one each, then the formula to pick a random item of those is
=INDEX(A1:A10;RANDBETWEEN(1;10))