RAND
Returns a random number between 0, inclusive, and 1, exclusive.
Syntax
Remarks
-
The result values will change every time a function is recalculated.
Examples
|
Formula |
Result |
|
=RAND() |
0.193414553 |
|
=RAND()+400 |
400.114774963 |
|
=RAND()*-2 |
-0.511866389 |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
Similar Functions
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
RANDBETWEEN
Returns an integer random number within a specified range. Syntax RANDBETWEEN(bottom; top) bottom: The minimum value in the given range. Eg., 100 top: The maximum value in the given range. Eg., 1000 Remarks The result values will change every ...RANDARRAY
Returns an array of random values in the given cell range. The minimum, maximum and type of values to be returned can also be specified. Syntax RANDARRAY([row]; [column]; [min]; [max]; [type]) row: Number of rows to be filled with the random ...CURRENCY
Converts the given value from one currency to another specified currency value. Syntax CURRENCY(value; "from"; "to") value: The value to be converted. Eg., 3500 from: The currency from which the value is to be converted. Must be given as a ...STANDARDIZE
Converts a random variable into a normalized variable, given its mean and standard deviation. Syntax STANDARDIZE(n; μ; σ) n: The value to normalize. Eg., 14 μ: Arithmetic mean of the distribution. Eg., 5 σ: The standard deviation of the ...PROB
Calculates the probability that a random value chosen falls between two given limits. Syntax PROB(values; probabilities; [start]; [end]) values: A range or array of numbers. Eg., A2:A5 probabilities: A range or array of numbers of the same size ...