Hello,
I was wondering how to create like a random number generator or something. So like +.09 is 57% and -1 is 43% and for it to randomly generate like 100 numbers, so that I could graph it later.
Any help is appreciated!
Hello,
I was wondering how to create like a random number generator or something. So like +.09 is 57% and -1 is 43% and for it to randomly generate like 100 numbers, so that I could graph it later.
Any help is appreciated!
not exactly sure what you mean, but try random() and randbetween()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Like for a cell to have a 57% chance to generate the number 0.90 and a 43% chance to generate the number -1.0
*bump*
Anyone have any ideas?
=if(rand()<0.57, 0.09, -1)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks