Forum Discussion

gijs van Bergen's avatar
gijs van Bergen
Copper Contributor
Oct 30, 2018

Problems concerning random RANDBETWEEN function and PROBABILITY

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...
excel
Formulas and Functions
Bikash_Kumar's avatar
Bikash_Kumar
Copper Contributor
Dec 15, 2019

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 16, 2019

    Bikash_Kumar 

    As variant

    =RANDBETWEEN(0,1000)/1000

Resources