#YOUCANLEARNECONOMICS
#ECONOMICS
There are two worksheet functions that are meant to generate random numbers in Excel: RAND and RANDBETWEEN.
RANDBETWEEN function would give you the random numbers, but there is a high possibility of repeats in the result.
RAND function is more likely to give you a result without repetitions. However, it only gives random numbers between 0 and 1. Using the fill handle is a pretty fast way of getting random numbers into a lot of cells. But there’s a faster way.
Just highlight all the cells you want to contain random numbers, type =RAND(), and press Ctrl + Enter.
Subscribe me @ / ezclassesfaghsa
Like me on Facebook @ / faghsa
Follow me on Twitter @ https://twitter.com/?lang=en
Mail ID: [email protected]