Forum Discussion

Viz's avatar
Viz
Brass Contributor
Jan 05, 2021

Lambda Example: Generate Fibonacci series

In this post, I would like to explain how I have used Lambda to create a function to generate a Fibonacci series array.   This example can also be used to understand how to create an array where th...
excel
office 365
lori_m's avatar
lori_m
Iron Contributor
Jan 06, 2021

Viz  I should have replied here instead of the other post for further discussion.

Have also tweaked recursive formula for the n=1 case.

FIB:
=LAMBDA(n,
       IF(n<=2,
       SEQUENCE(n,,0),
       LET(b,FIB(n-1),
            IF(SEQUENCE(n)<n,b,INDEX(b,n-1)+INDEX(b,n-2))
       )))

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 06, 2021

lori_m 

If add error handling as

=LAMBDA(n,
       IF(n<>INT(n),"use integer as argument",
       IF(n<=2,
       SEQUENCE(n,,0),
       LET(b,FIB(n-1),
            IF(SEQUENCE(n)<n,b,INDEX(b,n-1)+INDEX(b,n-2))
       ))))

it returns errors message as expected for FIB(10.1), but the spill as

for FIB(10+1e-14). Correction could be

=LAMBDA(n,
   IF(n<>INT(n),"use integer as argument",
      LET(m, INT(n),
         IF(m<=2,
         SEQUENCE(m,,0),
         LET(b,FIB(m-1),
         IF(SEQUENCE(m)<m,b,INDEX(b,m-1)+INDEX(b,m-2))
   )))))

Resources