Shortest way to have multiple Random #s in same cell

[droltac]

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

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[droltac]

What version of Excel are you using?

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Windows 10 w/ office 365
I have added that info to my profile

 

[Fluff]

Thanks for that, how about

=TEXTJOIN(", ",,RANDARRAY(,3,1,6,1))

 

[droltac]

Thanks for that, how about

=TEXTJOIN(", ",,RANDARRAY(,3,1,6,1))

Thanks for the quick reply. That will definitely give me the die rolls, but I unfortunately I need the total of all the rolls.

I did find this macro (but I would prefer a formula where as I have never used macros):

Sub DiceXlator()
Dim r As Range, v As String, NewForm As String, deemode As Boolean
Dim dee As String
dee = "d"
deemode = False
For Each r In Selection
v = r.Value
NewForm = "="
For i = 1 To Len(v)
ch = Mid(v, i, 1)
If ch = dee Then
NewForm = NewForm & "*RANDBETWEEN(1,"
deemode = True
Else
If Not IsNumeric(ch) And deemode Then
deemode = False
NewForm = NewForm & ")"
End If
NewForm = NewForm & ch
End If
Next i

If deemode Then
NewForm = NewForm & ")"
End If

r.Offset(0, 1).Formula = NewForm
Next r
End Sub

 

[Fluff]

In that case how about

=SUM(RANDARRAY(,3,1,6,1))

 

[droltac]

In that case how about

=SUM(RANDARRAY(,3,1,6,1))

That did it....thanks, you’re the best

 

[Fluff]

You're welcome & thanks for the feedback.