Functions / Math RAND Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/rand.md Ask Claude about this pageOpens Claude with this page's address Returns a random number between 0 and 1. Excel: Not checked yetGoogle Sheets: Not checked yetReturns: Number Volatile: recomputes on every evaluation Examples =RAND() Syntax RAND() Related ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.