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!