Rosetta Code

Pascal's triangle: Difference between revisions

Page Discussion

Pascal's triangle (view source)

Revision as of 21:01, 19 May 2021

4,983 bytes added ,  3 years ago
→‎{{header|Excel}}: Added a draft for Excel LAMBDA
(Add BCPL)
(→‎{{header|Excel}}: Added a draft for Excel LAMBDA)
Line 2,111:
{1,9,36,84,126,126,84,36,9,1}
</pre>
 
=={{header|Excel}}==
===LAMBDA===
 
Binding the names PASCAL and BINCOEFF to the following lambda expressions in the Name Manager of the Excel WorkBook:
 
(See [https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ LAMBDA: The ultimate Excel worksheet function])
 
{{Works with|Office 365 betas 2021}}
<lang lisp>PASCAL
=LAMBDA(n,
BINCOEFF(n - 1)(
SEQUENCE(1, n, 0, 1)
)
)
 
 
BINCOEFF
=LAMBDA(n,
LAMBDA(k,
QUOTIENT(FACT(n), FACT(k) * FACT(n - k))
)
)</lang>
 
{{Out}}
{| class="wikitable"
|-
|||style="text-align:right; font-family:serif; font-style:italic; font-size:120%;"|fx
! colspan="11" style="text-align:left; vertical-align: bottom; font-family:Arial, Helvetica, sans-serif !important;"|=PASCAL(A2)
|- style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff;"
|
| A
| B
| C
| D
| E
| F
| G
| H
| I
| J
| K
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 1
| style="font-style:italic" | Row number
| colspan="10" style="font-weight:bold" | PASCAL's TRIANGLE
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 2
| style="text-align:right; font-style:italic" | 1
| style="text-align:center; background-color:#cbcefb" | 1
|
|
|
|
|
|
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 3
| style="text-align:right; font-style:italic" | 2
| style="text-align:center" | 1
| style="text-align:center" | 1
|
|
|
|
|
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 4
| style="text-align:right; font-style:italic" | 3
| style="text-align:center" | 1
| style="text-align:center" | 2
| style="text-align:center" | 1
|
|
|
|
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 5
| style="text-align:right; font-style:italic" | 4
| style="text-align:center" | 1
| style="text-align:center" | 3
| style="text-align:center" | 3
| style="text-align:center" | 1
|
|
|
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 6
| style="text-align:right; font-style:italic" | 5
| style="text-align:center" | 1
| style="text-align:center" | 4
| style="text-align:center" | 6
| style="text-align:center" | 4
| style="text-align:center" | 1
|
|
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 7
| style="text-align:right; font-style:italic" | 6
| style="text-align:center" | 1
| style="text-align:center" | 5
| style="text-align:center" | 10
| style="text-align:center" | 10
| style="text-align:center" | 5
| style="text-align:center" | 1
|
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 8
| style="text-align:right; font-style:italic" | 7
| style="text-align:center" | 1
| style="text-align:center" | 6
| style="text-align:center" | 15
| style="text-align:center" | 20
| style="text-align:center" | 15
| style="text-align:center" | 6
| style="text-align:center" | 1
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 9
| style="text-align:right; font-style:italic" | 8
| style="text-align:center" | 1
| style="text-align:center" | 7
| style="text-align:center" | 21
| style="text-align:center" | 35
| style="text-align:center" | 35
| style="text-align:center" | 21
| style="text-align:center" | 7
| style="text-align:center" | 1
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 10
| style="text-align:right; font-style:italic" | 9
| style="text-align:center" | 1
| style="text-align:center" | 8
| style="text-align:center" | 28
| style="text-align:center" | 56
| style="text-align:center" | 70
| style="text-align:center" | 56
| style="text-align:center" | 28
| style="text-align:center" | 8
| style="text-align:center" | 1
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 11
| style="text-align:right; font-style:italic" | 10
| style="text-align:center" | 1
| style="text-align:center" | 9
| style="text-align:center" | 36
| style="text-align:center" | 84
| style="text-align:center" | 126
| style="text-align:center" | 126
| style="text-align:center" | 84
| style="text-align:center" | 36
| style="text-align:center" | 9
| style="text-align:center" | 1
|}
 
 
=={{header|F Sharp|F#}}==
Hout
9,659

edits

Retrieved from "https://rosettacode.org/wiki/Special:MobileDiff/75127"