Influencing RandBetween
Hello Everyone:
Sorry I posted this same question a few days ago, but I cannot find. I assume it didnt get posted? I am trying to create random numbers between 1 and 100. I am also trying to influence the output by referencing either a cell or a range. I have been working on this problem for a long time. I think I am looking for something like the formulas below, but they dont work. Hopefully it will give you an idea of what I am trying to do. =RANDBETWEEN((1,100), A1)) =RANDBETWEEN((1,100),SEEDS)) Thanks Art |
Influencing RandBetween
=RANDBETWEEN((1,100), A1))
This will work as long as the number in A1 is greater than RANDBETWEEN(1,100): =RANDBETWEEN(RANDBETWEEN(1,100),A1) =RANDBETWEEN((1,100),SEEDS)) I have no idea about that one! -- Biff Microsoft Excel MVP "Art W" wrote in message ... Hello Everyone: Sorry I posted this same question a few days ago, but I cannot find. I assume it didn't get posted? I am trying to create random numbers between 1 and 100. I am also trying to influence the output by referencing either a cell or a range. I have been working on this problem for a long time. I think I am looking for something like the formulas below, but they don't work. Hopefully it will give you an idea of what I am trying to do. =RANDBETWEEN((1,100), A1)) =RANDBETWEEN((1,100),SEEDS)) Thanks Art |
Influencing RandBetween
You did get a reply to your post of Aug 06, 2009;
about two hours after your post. '-- My free Special Randoms workbook will generate random numbers, between your max/min limits, that average a specified amount. Email and ask for it. Please use your real name and indicate your geographic location. Remove xxx from my email address... XX '-- Jim Cone Portland, Oregon USA "Art W" wrote in message Hello Everyone: Sorry I posted this same question a few days ago, but I cannot find. I assume it didnt get posted? I am trying to create random numbers between 1 and 100. I am also trying to influence the output by referencing either a cell or a range. I have been working on this problem for a long time. I think I am looking for something like the formulas below, but they dont work. Hopefully it will give you an idea of what I am trying to do. =RANDBETWEEN((1,100), A1)) =RANDBETWEEN((1,100),SEEDS)) Thanks Art |
Influencing RandBetween
Your previous post
http://www.microsoft.com/office/comm...d-08a601972664 If this post helps click Yes --------------- Jacob Skaria "Art W" wrote: Hello Everyone: Sorry I posted this same question a few days ago, but I cannot find. I assume it didnt get posted? I am trying to create random numbers between 1 and 100. I am also trying to influence the output by referencing either a cell or a range. I have been working on this problem for a long time. I think I am looking for something like the formulas below, but they dont work. Hopefully it will give you an idea of what I am trying to do. =RANDBETWEEN((1,100), A1)) =RANDBETWEEN((1,100),SEEDS)) Thanks Art |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com