I play D&D and I’m trying to find the shortest formula to generate multiple random #s in one cell.
so for example “rolling” 3 six sided dice.
I’ve been using =randbetween(1,6)+randbetween(1,6)+randbetween(1,6) but there must be a shorter way
i tried =3*randbetween(1,6) but this isn’t accurate because it is just generating 1 random # and then multiplying it by 3
any help would be much appreciated
so for example “rolling” 3 six sided dice.
I’ve been using =randbetween(1,6)+randbetween(1,6)+randbetween(1,6) but there must be a shorter way
i tried =3*randbetween(1,6) but this isn’t accurate because it is just generating 1 random # and then multiplying it by 3
any help would be much appreciated