All articles with 'trivia' Tag

Simulating Dice throws – the correct way to do it in excel

Published on Aug 13, 2008 in Learn Excel, simulation

If you ever had to simulate random outcomes in excel sheet, you might have already heard of about the spreadsheet function rand(), this little function generates a random fraction between 0 and 1 whenever you use it. So I usually write =round(rand()*12,0)int(rand()*12)+1 if I need a random number between 0 to 12. Of course, if […]

Continue »