| Line 28: |
Line 28: |
| | ==References== | | ==References== |
| | * [http://www.mathsisfun.com/pascals-triangle.html Pascal's Triangle ] | | * [http://www.mathsisfun.com/pascals-triangle.html Pascal's Triangle ] |
| − |
| |
| − |
| |
| − | '''PASCALTRIANGLE'''(level)
| |
| − |
| |
| − | where
| |
| − |
| |
| − | '''level''' is any real number
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | PASCALTRIANGLE function returns pascal's triangle for the given level.
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | PASCALTRIANGLE returns NaN if level is not a real number.
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − |
| |
| − | PASCALTRIANGLE
| |
| − |
| |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | Lets see an example in (Column2Row1)
| |
| − |
| |
| − | UNIQ9eec20026ff870ff-nowiki-00000002-QINU
| |
| − |
| |
| − | Returns 1,1,1,1,2,1 for PASCALTRIANGLE(3)
| |
| − |
| |
| − | </div>
| |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
| |
| − | ----
| |
| − | <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
| |
| − | ----
| |
| − | <div id="2SpaceContent" class="zcontent" align="left">
| |
| − |
| |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |+ Default Calci
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | Column2
| |
| − | | Column3
| |
| − | | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="1 1 " | 3
| |
| − | | class="sshl_f" | 1,1,1,1,2,1
| |
| − | | class=" sshl_f" |
| |
| − | | class="sshl_f sshl_f " |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | |
| |
| − | | class=" sshl_f SelectTD1 ChangeBGColor SelectTD1" |
| |
| − | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
| |
| − | | class=" sshl_f" |
| |
| − | | class="sshl_f sshl_f " |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | |
| |
| − | | class=" sshl_f" |
| |
| − | | class="sshl_f " |
| |
| − | | class="sshl_f " |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | |
| |
| − | | class=" sshl_f" |
| |
| − | | class="sshl_f " |
| |
| − | | class=" " |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | |
| |
| − | | class=" " |
| |
| − | | class="sshl_f " |
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | |
| |
| − | |
| |
| − | | class="sshl_f " |
| |
| − | | class=" " |
| |
| − | |}
| |
| − |
| |
| − | {|
| |
| − | | <span align="left">[[Image:calci1.gif]]</span>
| |
| − | |
| |
| − | |
| |
| − | [[Image:bold.gif]]
| |
| − | |
| |
| − | [[Image:italic.gif]]
| |
| − | |
| |
| − | [[Image:normal.gif]]
| |
| − | |
| |
| − | [[Image:underline.gif]]
| |
| − | |
| |
| − | [[Image:border.gif]]
| |
| − | |
| |
| − | [[Image:numbers.gif]]
| |
| − | |
| |
| − | [[Image:sort.gif]]
| |
| − | |
| |
| − | [[Image:formatcells.gif]]
| |
| − | |
| |
| − | [[Image:graphs.gif]]
| |
| − | | $
| |
| − | |}
| |
| − |
| |
| − | </div>
| |
| − | ----
| |