<div class="raw-html-embed">The RAND function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/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="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" 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.teamlab.info/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.teamlab.info/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