Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

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

RE: Excel

thank you!

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.