Panarchy Posted February 10, 2007 Report Share Posted February 10, 2007 Can someone please help? I need to simulate different things in Excel.I want the formulas for simulating a dice roll.Please help.I want it over like 50 cells in the one column to randomly work it out.I believe the formula is something like: =1+INT(6*RAND())But I need some help,Panarchy Link to comment Share on other sites More sharing options...
doug Posted February 10, 2007 Report Share Posted February 10, 2007 That should do it Panarchy. Link to comment Share on other sites More sharing options...
Panarchy Posted February 10, 2007 Author Report Share Posted February 10, 2007 But it didn't!!! I have never used Excel before and I need this to work! Link to comment Share on other sites More sharing options...
doug Posted February 10, 2007 Report Share Posted February 10, 2007 Try this=1+INT(6*RAND()) worked for me when I tried.Suggestion try building the formula in successive vertical cells. I.e. in your first cell type the rand function to check if it works. then copy and paste that into the cell below and add the 6* function. then copy that into the cell below and add the INT function. copy that into the cell below and add the 1+ function. This way you can check the "correctness" of your function at each stage. When I'm stuck this is my procedure. Good luck. Link to comment Share on other sites More sharing options...
Panarchy Posted February 10, 2007 Author Report Share Posted February 10, 2007 Thanks. I am a noob at excel, how do I make that formula for, lets say 10 more columns without copy+ paste? Link to comment Share on other sites More sharing options...
Irene Posted February 10, 2007 Report Share Posted February 10, 2007 Thanks. I am a noob at excel, how do I make that formula for, lets say 10 more columns without copy+ paste?I think you should be able to highlight the cells in column you have. Place your curser over the bottom right-hand corner where you see + under your curser. Right click and hold, then drag to the right. Link to comment Share on other sites More sharing options...
Panarchy Posted February 10, 2007 Author Report Share Posted February 10, 2007 Link to comment Share on other sites More sharing options...
doug Posted February 10, 2007 Report Share Posted February 10, 2007 No probs. You should have a dig into the Excel help function, it's very extensive. Type your question into the query cell and hit return. It will come back with all the answers you might need. Like Google really. Link to comment Share on other sites More sharing options...
Panarchy Posted February 10, 2007 Author Report Share Posted February 10, 2007 How do I ask a question?I use Excel 2007. Link to comment Share on other sites More sharing options...
doug Posted February 10, 2007 Report Share Posted February 10, 2007 I use Excel 2003 but I presume it will be about the same. Click on help and a separate panel should open Excel assistance. Type the question in the box. Link to comment Share on other sites More sharing options...
Panarchy Posted February 10, 2007 Author Report Share Posted February 10, 2007 This is what excel looks like for me: Link to comment Share on other sites More sharing options...
Irene Posted February 10, 2007 Report Share Posted February 10, 2007 In order to ask a question, you would need to press the question mark at the top right hand of the window, just above the binoculars. Link to comment Share on other sites More sharing options...
Gagaman Posted February 10, 2007 Report Share Posted February 10, 2007 Irene is right, also pressing F1 will show the help menu Link to comment Share on other sites More sharing options...
Panarchy Posted February 10, 2007 Author Report Share Posted February 10, 2007 Okay, thanks.PS: How do I make that formula work for more then just the 1 cell? With out ctrl+c + ctrl+v? Link to comment Share on other sites More sharing options...
Panarchy Posted February 11, 2007 Author Report Share Posted February 11, 2007 ______________________________________________NEW EXCEL!Okay, I need help again.How do I simulate a game of snakes and ladders on Excel? Link to comment Share on other sites More sharing options...
Recommended Posts