Rand and Randbetween Functions to generate percentages

[FerociousCamel]

How would you generate 25 (numbers) percentages such that a fourth of them are between 26% and 74.7%, and then the other three fourth are between 89% and 99%?

[kersplash]

A quarter of 25 is 6.25?

[FerociousCamel]

I'm not sure, thats what I was told to do...currently i have =(IF(RANDBETWEEN(1,4)=1,RANDBETWEEN(26,74.7),RANDBETWEEN(89,99))/100) but it seems to only do integers and not any decimals

[Phuocam]

Try:

=IF(RANDBETWEEN(1,4)=1,RANDBETWEEN(26000,74700),RANDBETWEEN(89000,99000))/100000

[FerociousCamel]

i think that worked
Thank You!