| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dice roll "problem"
Hi there Mike or Bob, have entered your tip and it worked in a way, when I type
"=RANDBETWEEN(1,6)" and click away to enter I get "#NAME?" displayed in the cell. Did I type the code wrong? Can there be a button in the sheet "named - Roll Dice" added to click on to generate the values? If so please help.. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dice roll "problem"
Try,
Tools|Addins Check the analysis toolpak and re-enter the formula. Mike "Markv" wrote: Hi there Mike or Bob, have entered your tip and it worked in a way, when I type "=RANDBETWEEN(1,6)" and click away to enter I get "#NAME?" displayed in the cell. Did I type the code wrong? Can there be a button in the sheet "named - Roll Dice" added to click on to generate the values? If so please help.. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dice roll "problem"
Yeah thats better - thanks bud.
Perfect. "Mike H" wrote: Try, Tools|Addins Check the analysis toolpak and re-enter the formula. Mike "Markv" wrote: Hi there Mike or Bob, have entered your tip and it worked in a way, when I type "=RANDBETWEEN(1,6)" and click away to enter I get "#NAME?" displayed in the cell. Did I type the code wrong? Can there be a button in the sheet "named - Roll Dice" added to click on to generate the values? If so please help.. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dice roll "problem"
Please, Please, Please!
Does it never occur to anyone that if they are struggling with an Excel function it might be useful to look up the function in Excel help? Or, to give a shorter answer, RTFM. Not a specific criticism of you, Mark, but advice for other users too. -- David Biddulph "Markv" wrote in message ... Hi there Mike or Bob, have entered your tip and it worked in a way, when I type "=RANDBETWEEN(1,6)" and click away to enter I get "#NAME?" displayed in the cell. Did I type the code wrong? .... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| How do I set up a "roll over" counter in excel 2003? | Excel Worksheet Functions | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
