From Bfx_help(...)

90 ==========================Non volatile random numbers===========================

91 i is a positive integer number, b is the bottom value, t (>b) is the top value

92 <r> is an optional range

93 random_number = BfX_Ran(i; <r>) 0 <= random_number <= 1]

94 b <= random_number <= t = BfX_Ranb(i; b; t; <r>)

95 c and s are center and width of normal distribution

96 normal distribution b <= random_number <= t= BfX_Rang(i; c; s; b; t; <r>)

97 use <r> to link cells to guide Excels calculation order

i is the seed.

<r> is a cell or a range

B C D

2 seed 1234567

3

4 0,051118901 =BfX_Ran(seed)

5 0,207298019 =BfX_Ran(seed;C4)

6 0,529684412 =BfX_Ran(seed;C5)

7 0,164931189 =BfX_Ran(seed;C6)

8 0,760708209 =BfX_Ran(seed;C7)

9 0,711878956 =BfX_Ran(seed;C8)

10 0,434484066 =BfX_Ran(seed;C9)

11 0,032066679 =BfX_Ran(seed;C10)

12 0,018770791 =BfX_Ran(seed;C11)

13 0,197369616 =BfX_Ran(seed;C12)

14

15 bfx_ran refers to the previous cell in order to force

16 a specific order of random number (cell) processing

My random number is non volatile.

Volatile means according to MS:

Excel supports the concept of a volatile function, that is, one whose value cannot be assumed to be the same from one moment to the next even if none of its arguments (if it takes any) has changed. Excel reevaluates cells that contain volatile functions, together with all dependents, every time that it recalculates. For this reason, too much reliance on volatile functions can make recalculation times slow. Use them sparingly.

The following Excel functions are volatile:

NOW

TODAY

RAND

OFFSET

INDIRECT

INFO (depending on its arguments)

CELL (depending on its arguments)