dynamic formula question with links to two other values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2020
08:23 AM
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.