excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 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:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.