Using Excel I am attempting to create a formula using the RAND function but with percentages allocated to each set of random numbers. for example I would like a number between 1.00 and 1.99 to appear 54 percent of the time, a number between 2.00 and 2.99 to appear 13 percent of the time and a number between 3.00 and 100.00 to appear 33 percent of the time. Any help with this? Thank you!

New contributor

Riley Miller is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.