dynamic formula question with links to two other values

jsohn
Community Member

how do I write a formula question where a random number is chosen from a range, and then based on that number a second number/symbol (maybe from a lookup table) is generated? Thinking of a random atomic number, that when chosen also returns the atomic symbol.

ideally, we want to randomly choose an atomic number 1-118, have the corresponding atomic symbol AND an appropriate mass number (atomic number x another variable between 1.9 and 2.5) displayed.

Labels (1)
0 Likes