<div class="raw-html-embed">
	The RAND function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#mathtrigonometry" onclick="onhyperlinkclick(this)">math and trigonometry functions</a>. The function returns a random number greater than or equal to 0 and less than 1. It does not require any argument.
	<h5 class="pt8">Syntax</h5>
	RAND()
	<h5 class="pt8">Notes</h5>
	<a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the RAND function.

	<h5 class="pt8">Examples</h5>
	The figure below displays the result returned by the RAND function.
	<img alt="RAND Function" src="https://static-helpcenter.onlyoffice.com/rand_cac47306a5.png">
	To generate a random real number between a and b, use the following formula replacing a and b with your own values: =RAND()*(b-a)+a
	<img alt="RAND Function" src="https://static-helpcenter.onlyoffice.com/rand2_d935a6c98e.png">
</div>

RAND function

Docs

RAND function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud