Use the Segoe UI Symbol font to get the six sides of the dice
⚀⚁⚂⚃⚄⚅
Then use the =RANDBETWEEN(1,6) formula to get random numbers between 1 and 6.
After that, use a VLOOKUP formula to find the side of the dice.
Finally, copy the dice as linked pictures and press F9 to 'roll the dice'
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 2006
---------------------------------------------------------------------------------
RECENT VIDEOS:
- Calendar Heatmap Template Excel • Calendar Heatmap Templ...
- How to make a dynamic calendar in excel • How to make a dynamic ...
- How to make a calendar heatmap in excel • How to make a calendar...
Негізгі бет Roll of the dice in excel
No video
Пікірлер: 16