Ask Your Question

in a spreadsheet, how can I insert variable outcomes in a cell?

asked 2019-05-06 20:41:04 +0100

Nikaki2004 gravatar image

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)

edit retag flag offensive close merge delete


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.

Lupp gravatar imageLupp ( 2019-05-06 21:33:38 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-05-08 14:16:41 +0100

erAck gravatar image

Place your 10 items in cells A1:A10 one each, then the formula to pick a random item of those is

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-06 20:41:04 +0100

Seen: 33 times

Last updated: May 08