Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

RAND( ) [Category: Math]

Returns an evenly distributed random number greater than or equal to 0 and

less than 1. A new random number is returned every time the worksheet is

calculated. Guru Tip: To generate random numbers between 1 and 10, use

=INT(RAND()*10)+1

RANDBETWEEN(bottom,top) [Category: Math]*

Returns a random number between the numbers you specify. A new random

number is returned every time the worksheet is calculated. Guru Tip: Unlike

RAND, this function returns integers. When I need to add some "noise" to data,

I will add =RAND(-3,3) to subtract/add anywhere from 1 to 3 to each number in

a range. If you want to select random items from a list, the RANDBETWEEN() is

a perfect argument for INDEX: =INDEX(J1:J30,RANDBETWEEN(1,30)).

RANK(number,ref,order) [Category: Statistical]]

Returns the rank of a number in a list of numbers. The rank of a number is its

size relative to other values in a list. (If you were to sort the list, the rank of the

number would be its position.) Guru Tip: most people leave off the 3rd argument

which means that the highest value receives a rank of 1. However, if you are

ranking golf scores, put any non-zero value as the 3rd argument. Then the

lowest score receives a rank of 1.

Rank deals with ties in the same way that the sporting pages would. In the

example below, two scores are tied for second. Both of these scores receive a

2 and none of the scores receive a 3. The next score receives a 4. Similar ties

at 5th and 7th mean that no one is ranked 6th or 8th.