How To Use Excel RAND Function

    how to use excel rand function

    Quick Intro

    Excel RAND Function is the best fit to randomly generate numbers in excel. It can generate evenly distributed numbers between 0 and 1.

    Every time when you refresh your worksheet calculations, it will return a new random number.

    In below example, I have entered the random numbers in range using RAND Function.

    Excel RAND Function Generate Random Numbers

    Syntax

    RAND()

    • There is no argument to input in RAND.

    Additional Information on Excel RAND Function

    • RAND is a volatile function which will recalculate whenever workbook is open or calculation made. In simple words, whenever you hit enter or refresh your workbook it will recalculate the values.
    • If you don’t want RAND to recalculate numbers, you can convert those number into values by using paste special or after entering RAND Function into the cell press F9 (In Edit Mode).

    Stop Recalculation For Excel RAND Function

    • To enter the random numbers in a selected range.
      • Just select the range first, then type =RAND() & press Ctrl + Enter.
    • By using RAND you can also generate random percentage from 0% to 100%.

    Example

    In above example, we have used RAND Function to create a formula which will generate random numbers between 50 and 100.

    Examples For Excel RAND Function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel RAND Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There is also you have RANDBETWEEN function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.