http://wiki.zcubes.com/index.php?action=history&feed=atom&title=Manuals%2Fcalci%2FRANDBBETWEEN Manuals/calci/RANDBBETWEEN - Revision history 2026-06-25T14:54:09Z Revision history for this page on the wiki MediaWiki 1.35.2 http://wiki.zcubes.com/index.php?title=Manuals/calci/RANDBBETWEEN&diff=561&oldid=prev MassBot1: Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=..." 2013-10-25T02:42:58Z <p>Created page with &quot;&lt;div id=&quot;16SpaceContent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt; Syntax &lt;/div&gt;&lt;/div&gt; ---- &lt;div id=&quot;2SpaceContent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=...&quot;</p> <p><b>New page</b></p><div>&lt;div id=&quot;16SpaceContent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;<br /> <br /> Syntax<br /> <br /> &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;2SpaceContent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;<br /> <br /> Examples<br /> <br /> &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;8SpaceContent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;'''&lt;font face=&quot;Times New Roman&quot;&gt;''''''''''''&lt;font size=&quot;6&quot;&gt; &lt;/font&gt;''' '''''''''&lt;/font&gt;'''&lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;11SpaceContent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox mceEditable&quot; align=&quot;justify&quot;&gt;<br /> <br /> &lt;font size=&quot;5&quot;&gt;Description&lt;/font&gt;<br /> <br /> &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;10SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;'''&lt;font face=&quot;Times New Roman&quot;&gt;&lt;font size=&quot;6&quot;&gt; &lt;font size=&quot;6&quot;&gt;RANDBBETWEEN&lt;/font&gt; &lt;font size=&quot;6&quot;&gt; &lt;/font&gt; &lt;/font&gt;&lt;/font&gt;'''&lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;3SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;br /&gt;&lt;div id=&quot;9Space&quot; class=&quot;gamizbox&quot; title=&quot;9Space&quot;&gt;&lt;div id=&quot;9SpaceHeader&quot; class=&quot;zheaderstyle&quot; title=&quot;Double-click to start and stop editing the header.&quot;&gt;&lt;center&gt;&lt;/center&gt;&lt;/div&gt;&lt;div id=&quot;9SpaceRollup&quot; title=&quot;Double-click to rolldown&quot; align=&quot;left&quot;&gt;&lt;span&gt;&lt;span id=&quot;9SpaceRollupContent&quot; align=&quot;center&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div id=&quot;9SpaceCover&quot;&gt;&lt;div id=&quot;9SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;<br /> <br /> &lt;font size=&quot;3&quot;&gt;&lt;font face=&quot;Times New Roman&quot;&gt;Let’s see an example in (Column1 Row 1, Column2 Row 1)&lt;/font&gt;&lt;/font&gt;<br /> <br /> &lt;font size=&quot;3&quot;&gt;RANDBETWEEN (B, T)&lt;/font&gt;<br /> <br /> &lt;font size=&quot;3&quot;&gt;RANDBETWEEN (C1R1, C2R1)&lt;/font&gt;<br /> <br /> &lt;font size=&quot;3&quot;&gt;ie. =RANDBETWEEN (20,100) is a random number between 20 and 100.&lt;/font&gt;<br /> <br /> &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;5SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;br /&gt;&lt;div id=&quot;1Space&quot; class=&quot;gamizbox&quot; title=&quot;1Space&quot;&gt;&lt;div id=&quot;1SpaceHeader&quot; class=&quot;zheaderstyle&quot; title=&quot;Double-click to start and stop editing the header.&quot;&gt;&lt;center&gt;&lt;/center&gt;&lt;/div&gt;&lt;div id=&quot;1SpaceRollup&quot; title=&quot;Double-click to rolldown&quot; align=&quot;left&quot;&gt;&lt;span&gt;&lt;span id=&quot;1SpaceRollupContent&quot; align=&quot;center&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div id=&quot;1SpaceCover&quot;&gt;&lt;div id=&quot;1SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;<br /> <br /> &lt;font size=&quot;3&quot;&gt;&lt;font face=&quot;Times New Roman&quot;&gt;It calculates a random integer number berween the numbers which we specify.&lt;/font&gt;&lt;/font&gt;<br /> <br /> &lt;font size=&quot;3&quot; face=&quot;Times New Roman&quot;&gt; &lt;/font&gt;<br /> <br /> &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;12SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;br /&gt;&lt;div id=&quot;7Space&quot; class=&quot;gamizbox&quot; title=&quot;7Space&quot;&gt;&lt;div id=&quot;7SpaceHeader&quot; class=&quot;zheaderstyle&quot; title=&quot;Double-click to start and stop editing the header.&quot;&gt;&lt;center&gt;&lt;/center&gt;&lt;/div&gt;&lt;div id=&quot;7SpaceRollup&quot; title=&quot;Double-click to rolldown&quot; align=&quot;left&quot;&gt;&lt;span&gt;&lt;span id=&quot;7SpaceRollupContent&quot; align=&quot;center&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div id=&quot;7SpaceCover&quot;&gt;&lt;div id=&quot;7SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;&lt;font size=&quot;3&quot; face=&quot;Times New Roman&quot;&gt; &lt;/font&gt;'''RANDBETWEEN'''('''B,T''')<br /> <br /> '''B'''   is the smallest integer and '''T'''   is the largest integer.<br /> <br /> &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;4SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div&gt;<br /> <br /> {| id=&quot;TABLE1&quot; class=&quot;SpreadSheet blue&quot;<br /> |- class=&quot;even&quot;<br /> | class=&quot; &quot; |<br /> | Column1<br /> | class=&quot; &quot; | Column2<br /> | class=&quot; &quot; | Column3<br /> | class=&quot; &quot; |<br /> | class=&quot; &quot; | Column4<br /> |<br /> |- class=&quot;odd&quot;<br /> | class=&quot; &quot; | Row1<br /> | class=&quot;sshl_f&quot; | 20<br /> | class=&quot;sshl_f&quot; | 100<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot;sshl_f&quot; |<br /> |<br /> |- class=&quot;even&quot;<br /> | class=&quot; &quot; | Row2<br /> | class=&quot;sshl_f&quot; | 74<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot;sshl_f&quot; |<br /> |<br /> |- class=&quot;odd&quot;<br /> | Row3<br /> | class=&quot;sshl_fSelectTD SelectTD &quot; |<br /> &lt;div id=&quot;4Space_Handle&quot; title=&quot;Click and Drag to resize CALCI Column/Row/Cell. It is EZ!&quot;&gt;&lt;/div&gt;&lt;div id=&quot;4Space_Copy&quot; title=&quot;Click and Drag over to AutoFill other cells.&quot;&gt;&lt;/div&gt;<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot; &quot; |<br /> | class=&quot;sshl_f&quot; |<br /> |<br /> |- class=&quot;even&quot;<br /> | Row4<br /> | class=&quot;sshl_f&quot; |<br /> | class=&quot;sshl_f&quot; |<br /> |<br /> | class=&quot; &quot; |<br /> | class=&quot;sshl_f&quot; |<br /> |<br /> |- class=&quot;odd&quot;<br /> | Row6<br /> | class=&quot;sshl_f &quot; |<br /> &lt;div id=&quot;4Space_Copy&quot; title=&quot;Click and Drag over to AutoFill other cells.&quot;&gt;&lt;/div&gt;<br /> | class=&quot;sshl_f&quot; |<br /> |<br /> | class=&quot;sshl_f&quot; |<br /> |<br /> |<br /> |}<br /> <br /> &lt;div align=&quot;left&quot;&gt;&lt;/div&gt;''''''&lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;</div> MassBot1