| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Numbers
Hi!
How can we generate numbers specificly between 1 and 90? Thanx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
=1+RAND()*89
HTH. Best wishes Harald "Eve" skrev i melding ... Hi! How can we generate numbers specificly between 1 and 90? Thanx |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
It worx!!
Thank you:) €˛Harald Staff€¯ ezt Ć*rta: =1+RAND()*89 HTH. Best wishes Harald "Eve" skrev i melding ... Hi! How can we generate numbers specificly between 1 and 90? Thanx |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
Eve, There is also a RandBetween Function that might work.
=RandBetween(1,90) I'm not sure what is required to make that work however. Charles Harald Staff wrote: =1+RAND()*89 HTH. Best wishes Harald "Eve" skrev i melding ... Hi! How can we generate numbers specificly between 1 and 90? Thanx |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
Hi Charles
It requires the Analysis Toolpack installed. You can not count on it in multiuser or multilingual environments. HTH. Best wishes Harald "Die_Another_Day" skrev i melding ups.com... Eve, There is also a RandBetween Function that might work. =RandBetween(1,90) I'm not sure what is required to make that work however. Charles Harald Staff wrote: =1+RAND()*89 HTH. Best wishes Harald "Eve" skrev i melding ... Hi! How can we generate numbers specificly between 1 and 90? Thanx |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
Tx Harold, Do you know when the Analysis Toolpack became available?
Charles Harald Staff wrote: Hi Charles It requires the Analysis Toolpack installed. You can not count on it in multiuser or multilingual environments. HTH. Best wishes Harald "Die_Another_Day" skrev i melding ups.com... Eve, There is also a RandBetween Function that might work. =RandBetween(1,90) I'm not sure what is required to make that work however. Charles Harald Staff wrote: =1+RAND()*89 HTH. Best wishes Harald "Eve" skrev i melding ... Hi! How can we generate numbers specificly between 1 and 90? Thanx |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
Charles -
The Analysis ToolPak was available at least as far back as Excel 5. - Mike http://www.mikemiddleton.com "Die_Another_Day" wrote in message oups.com... Tx Harold, Do you know when the Analysis Toolpack became available? Charles Harald Staff wrote: Hi Charles It requires the Analysis Toolpack installed. You can not count on it in multiuser or multilingual environments. HTH. Best wishes Harald "Die_Another_Day" skrev i melding ups.com... Eve, There is also a RandBetween Function that might work. =RandBetween(1,90) I'm not sure what is required to make that work however. Charles Harald Staff wrote: =1+RAND()*89 HTH. Best wishes Harald "Eve" skrev i melding ... Hi! How can we generate numbers specificly between 1 and 90? Thanx |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
Also, afaik these functions will be biult-in in the next Excel version.
Which makes them as reliable as other Excel functions. That alone makes an upgrade worth it. Best wishes Harald "Die_Another_Day" skrev i melding oups.com... Tx Harold, Do you know when the Analysis Toolpack became available? Charles Harald Staff wrote: Hi Charles It requires the Analysis Toolpack installed. You can not count on it in multiuser or multilingual environments. HTH. Best wishes Harald "Die_Another_Day" skrev i melding ups.com... Eve, There is also a RandBetween Function that might work. =RandBetween(1,90) I'm not sure what is required to make that work however. Charles Harald Staff wrote: =1+RAND()*89 HTH. Best wishes Harald "Eve" skrev i melding ... Hi! How can we generate numbers specificly between 1 and 90? Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
| I want random numbers generated without repeating numbers | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Linear Mode
