Forum Discussion

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

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

Diamond Contributor

Dec 16, 2019

Bikash_Kumar

As variant

=RANDBETWEEN(0,1000)/1000