Fibonacci sequence: Difference between revisions
Content deleted Content added
Line 3,980:
=={{header|Excel}}==
===LAMBDA===
{{Works with|Office 365 Betas 2021}}▼
Binding the name FIBONACCI to the following lambda in the Excel worksheet Name Manager:
(See [https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ The LAMBDA worksheet function])
▲{{Works with|Office 365 Betas 2021}}
<lang lisp>FIBONACCI
=LAMBDA(n,
Line 4,010 ⟶ 4,009:
MAX(COLUMNS(xs), COLUMNS(ys))
),
IF(rowIndexes <= nx,
INDEX(xs, rowIndexes, colIndexes),
INDEX(ys, rowIndexes - nx, colIndexes)
| |||