Problems concerning random RANDBETWEEN function and PROBABILITY

[gijs van Bergen]

Hi there people!

I really have a problem concerning the following:

I want to create a RANDBETWEEN function that deals with the probability of getting any number between two constraints. I tried the following on the attached data:

=CHOOSE(MATCH(RAND();{AR3;AR4;AR5;AR6;AR7;AR8});RANDBETWEEN(0;AQ4-1);RANDBETWEEN(AQ4;AQ5-1);RANDBETWEEN(AQ5;AQ6-1);RANDBETWEEN(AQ6;AQ7-1);RANDBETWEEN(AQ7;AQ8-1);RANDBETWEEN(AQ8;AQ9-1))

COLUMN AR is cumulative probability

COLUMN AQ are the numbers 

[#2]

@gijs van Bergen 

I have a (possibly) related query. In using RAND and RANDBETWEEN functions on Excel in Office 365, how do I get to set non-integer decimal values to be returned? Ideally, how could I set % values to be returned?

Thanks in advance to the community for help.

[#3]

@Bikash_Kumar 

As variant

=RANDBETWEEN(0,1000)/1000