Random percentages

[Davemk]

Hi,

I need a bit of help for a work project i'm currently looking in to.

I need to return a random value that is between 10-25% higher than a specified value. For example, I have a figure of £314.25 and, in the next cell, I need to get a figure that is randomly between 10-25% higher.

I know it's not really much to go on and it's my first time posting here so apologies if I've not provided enough information.

Thanks in advance

Dave

 

[Eric W]

Welcome to the board.

Try:

=A1*(1+RANDBETWEEN(10,25)/100)

 

[joeu2004]

Hi,
I need to return a random value that is between 10-25% higher than a specified value. For example, I have a figure of 314.25 and, in the next cell, I need to get a figure that is randomly between 10-25% higher.

Ostensibly, if 314.25 is in A1:

=ROUND(A1*(1 + RANDBETWEEN(10,25)%), 2)

However, that generates only "integer" percentages 10%, 11%, 12%, etc. If you want percentages with 2 percentage decimal places -- 10.00%, 10.01%, 10.02% etc -- one way to do that is:

=ROUND(A1*(1 + RANDBETWEEN(1000,2500)/10000), 2)

For unlimited decimal places, you could write:

=ROUND(A1*(1 + (10% + (25%-10%)*RAND())), 2)
or
=ROUND(A1*(1 + (10% + 15%*RAND())), 2)

 

[Davemk]

Welcome to the board.

Try:

=A1*(1+RANDBETWEEN(10,25)/100)

Thanks. This appears to work and provides what I need.

Appreciate the speedy response