Rand() formula
 

In your example, how did you arrive with the result 5 ??
--
Gary''s Student - gsnu200827


"Luke" wrote:

I have reading posts that include the rand() function. I am no where near a
mathmatician, my efforts have errors at every turn, so I need to ask for your
help.

Is it posible to use rand() in a formula that would respond with a result
output in column B to my inputting new data into column A? If not Rand(),
then what would work?

simple example:
A B
1 6 5 Output - highest probability to be placed in A15
2 5 based on col A's history.
3 2
4 0
5 7
6 3
7 9
8 4
9 1
10 1
11 8
12 2
13 0
14 3

Thank you for your help
Luke

Rand() formula
 

Gary,
the 5 is just an example. I could never get it to work so I have no clue as
to what the result would really be.
Thanks for your consideration
Luke

"Gary''s Student" wrote:

In your example, how did you arrive with the result 5 ??
--
Gary''s Student - gsnu200827


"Luke" wrote:

I have reading posts that include the rand() function. I am no where near a
mathmatician, my efforts have errors at every turn, so I need to ask for your
help.

Is it posible to use rand() in a formula that would respond with a result
output in column B to my inputting new data into column A? If not Rand(),
then what would work?

simple example:
A B
1 6 5 Output - highest probability to be placed in A15
2 5 based on col A's history.
3 2
4 0
5 7
6 3
7 9
8 4
9 1
10 1
11 8
12 2
13 0
14 3

Thank you for your help
Luke

Rand() formula
 

Please see response to "Bernd P" for better understanding of what I am trying
to do. Thank you Gary
Luke

"Gary''s Student" wrote:

In your example, how did you arrive with the result 5 ??
--
Gary''s Student - gsnu200827


"Luke" wrote:

I have reading posts that include the rand() function. I am no where near a
mathmatician, my efforts have errors at every turn, so I need to ask for your
help.

Is it posible to use rand() in a formula that would respond with a result
output in column B to my inputting new data into column A? If not Rand(),
then what would work?

simple example:
A B
1 6 5 Output - highest probability to be placed in A15
2 5 based on col A's history.
3 2
4 0
5 7
6 3
7 9
8 4
9 1
10 1
11 8
12 2
13 0
14 3

Thank you for your help
Luke