I know it truly isn't random if it is weighted, I just don't know how else to ask it.
Is there an easy way to do a weighted random between two values?
I have two values and am picking random numbers between them.
Is there a way to have middle numbers be selected more often lower/higher numbers.
(A Triangle on a scatter chart)
If not then is there a way to have higher numbers picked more commonly then lower and vise versa?
( An increasing slope or a decreasing slope on a scatter chart)
I assume this would have to be done with percent some how.
I would like a formula rather than using a ton of conditions, but I will take what is best.