Seed

The random number generator seed can be set in two ways:

1. You can select Worksheet Options from the Tools menu, and change its value at the start of the worksheet from the Built-in Variables tab.

   – or –

2. You can change its value in the body of the worksheet using the Seed function.

Seed(x) Resets the value of Seed to x, and returns the previous value.

Arguments:

In each case, unless noted,

• x is a dimensionless integer between 1 and 2147483647.

Each seed value selects a unique sequence of uniformly distributed quasi-random numbers.

Note:

• If Seed is called before any random number generator functions, its return value is the same as that set in Worksheet options. If Seed is called after a random number generator function, its return value is the subsequent value of the seed used to calculate the next number in the sequence.

QuickSheet