top of page
Search

Get a RANDom number between 0 and 1

  • Ketul Patel
  • Jan 19, 2017
  • 1 min read

=RAND()

RAND function helps you get a random number between 0 and 1

Use the RAND function to get a random number between 0 and 1. For example, =RAND() will generate a number like 0.3334323

RAND calculates a new value each time the worksheet is calculated. To stop random numbers from being updated, copy the cells that contain RAND to the clipboard, then use Paste Special > Values to convert to text.

 
 
 
Featured Posts
Recent Posts
bottom of page