Syntax
=RAND()Arguments
RAND takes no arguments. Type =RAND() with empty parentheses.
How to use RAND
RAND is volatile: it recalculates every time the workbook changes, so its result can differ each time.
RAND takes no required arguments. Type =RAND( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=AND(RAND()>=0, RAND()<1)Result Related math functions
- POWERReturns a number raised to a power.
- PRODUCTMultiplies numbers and the numbers in ranges.
- QUOTIENTReturns the whole number part of a division.
- RADIANSConverts an angle from degrees to radians.
- RANDARRAYReturns an array of random numbers; you choose the size, the range and whether they are whole numbers.
- RANDBETWEENReturns a random whole number between two numbers (both included).
- ROMANConverts a number to Roman numerals as text; form 0 is classic and 1 to 4 are ever more concise.
- ROUNDRounds a number to a given number of digits, halves away from zero.
- ROUNDDOWNRounds a number toward zero to a given number of digits.