Hello all!
I am in the process of making an excel spreadsheet to roll dice of different sides (4,6,8,20,100,etc.). I want to be able to tell Excel how many dice I want to roll and have each individual die roll be displayed. For instance, if I tell Excell to roll four 6-sided dice, it would return: 3,2,5,5.
I know this has to use the Randbetween function, but how do you tell Excel to run this function x number of times and display the results too?
Any help would be greatly appreciated!
Nick
Something like this..
Life's a spreadsheet, Excel!
Say thanks, Click *
That is really cool!
What exactly does does the ROW command do? That is a new one for me! Works like a charm, though! Thanks!
Nick
Row function simply returns row number of cell specified. See this..
http://office.microsoft.com/en-us/ex...010342861.aspx
Extra reading COLUMN function
http://office.microsoft.com/en-us/ex...091.aspx?CTT=1
Just curious, what game are you playing?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks