One way

=TEXT(ROUND(RAND()*(0.5-0.1)+0.1,1),"0%")


Regards,

Peo Sjoblom

"Steel Bananana" wrote:

Hi!
I'm running an online body jewelry business, and I would love to do a
"roulette" type of promotion. Basically, I want to enter a coupon code into
one column, and create a random percentage in the second column. There
doesn't need to be any correlation between the two columns, and repitition is
not an issue.
If it's possible, I don't mind copying and pasting the formula from one cell
to the next to generate the number as I go along...
One issue that I will have is that I want it to generate one of the following:
10%, 15%, 20%, 25%, 30%, 35%, 40%, and 50%.
(Obviously, I want to keep the 50%'s to a minimum, but random is random...)
Thanks in advance for the help!
Kim

PS: Excel 2003 (or I could do it at work with 2000 if it's easier...)
http://www.steelbanana.com