Forum Discussion

Chris_Gross's avatar
Chris_Gross
Icon for Microsoft rankMicrosoft
Dec 03, 2020

LAMBDA Examples: Distance between two cities

This post is the first of a series where we will be sharing out examples of lambdas. This is intended to highlight lambdas we have cooked up that show the power of this new super-charged function. Ad...
excel
Formulas and Functions
  • lori_m's avatar
    lori_m
    Steel Contributor
    Jan 06, 2021

    Viz  I tried Fibonacci series too and came up with two options:

    1. Recursive

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

    2. Non-recursive (Binet)

    =LAMBDA(n,ROUND(((1+5^0.5)/2)^SEQUENCE(n,,0)/5^0.5,))

     

Resources