Manuals/calci/RAND

Revision as of 20:42, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Syntax

Remarks

Examples

''''''' ''''

Description

RAND

RAND( )

	Column1	Column2	Column3		Column4
Row1	0.7135
Row2
Row3
Row4
Row6

'

For generating random number between two numbers n1 and n2,calculate

RAND()*(n2-n1)+n1

It calculates an evenly distributed random real number between 0 and 1.

ie =RAND( ) is a value that varies and which is greater than zero and less than one.

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/RAND&oldid=560"