Is there a way to construct a formula that specifies the number of RANDBETWEEN functions based upon a number in an adjacent cell? The spreadsheet has more than 300 rows, making it a laborious task to do manually,
Here’s an example of what I am trying to achieve:
COL A | COL B |
---|---|
1 | =RANDBETWEEN(1,8) |
2 | =RANDBETWEEN(1,8)+RANDBETWEEN(1,8) |
3 | =RANDBETWEEN(1,8)+RANDBETWEEN(1,8)+RANDBETWEEN(1,8) |
Thanks for any assistance!