|
Random Numbers
Hi!
How can we generate numbers specificly between 1 and 90? Thanx |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com