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