Ask Your Question
0

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

Comments

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
0

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

=INDEX(A1:A10;RANDBETWEEN(1;10))
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 33 times

Last updated: May 08