Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i set up rand or rand between to give only -1 or 1? | Excel Worksheet Functions | |||
=INT(0+(1-0+1)*RAND()) wtf? | Excel Worksheet Functions | |||
Duplicates in Rand Formula | Excel Discussion (Misc queries) | |||
Creating a formula using RAND | Excel Worksheet Functions | |||
How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions |