Excel RAND function Function RAND Description Excel RAND function returns a random number between 0 to 1 Syntax RAND() Usage Note: Every time you calculate any cell of worksheet RAND generates a new random value.