Today’s function is DICE_ROLL. Returns random values from the required number of dice

 Today’s function is DICE_ROLL. Returns random values from the required number of dice

BY / Mark Proctor

Mark Proctor

=LAMBDA(numberOfDice,

 INDEX({"⚀","⚁","⚂","⚃","⚄","⚅"},RANDARRAY(numberOfDice,1,1,6,TRUE)))

-----

LAMBDA(a,CHOOSE(RANDARRAY(a,1,1,6,TRUE),"⚀","⚁","⚂","⚃","⚄","⚅"))=