Annalisa has attended:
Excel Intermediate course
Excel Advanced course
Excel
what the is "random" formula, where random numbers are generated?
RE: Excel
Hi Annalisa
To use the formula to create random numbers you first need to check if you have the relevant Add-in loaded on your computer. To do this:
1. Click the "Tools" menu and select "Add-Ins...".
2. Check the "Analysis Toolpak - VBA" item from the list.
3. Click OK.
4. Excel will now attempt to install this Add-in. (You may need your Office installation CD)
NB: If the "Analysis Toolpak - VBA" is already checked, then just click "Cancel".
When this is done click the cell where you would like to create the random number. Then type the following formula:
=Randbetween(a,b)
Replace the "a" and "b" with the range (starting range, ending range). (Eg. =randbetween(1,5) might select 5 or 2).
Press Enter.
NB: Press the F9 key to select a new random number.
Hope this helps
Carlos