Lambda Example: Generate Fibonacci series

Given the limitations we have with Excel precision for large Fibonacci numbers it is worth to consider this approach that uses Excel Javascript API, with the help of Microsoft Garage Project: https://github.com/OfficeDev/script-lab

Here a https://www.nayuki.io/page/fast-fibonacci-algorithms (something we discussed in this post also trying to implement it in Excel):

/**
 * @customfunction
 *  {number} n The nth Fibonacci number to be calculated
 * @returns {string} The Fibonacci number
 */
function fib(n) {
  function rec(n) {
    if (n == 0)
      return [0n, 1n];
    else {
      const [a, b] = rec(Math.floor(n / 2));
      const c = a * (b * 2n - a);
      const d = a * a + b * b;
      if (n % 2 == 0)
        return [c, d];
      else
        return [d, c + d];
    }
  }
  if (n < 0)
    throw RangeError("Negative arguments not implemented");
  return rec(n)[0].toString();
}

Please keep in mind that @tags in the comment section are required to register properly the custom function. The calculation is carried out with BigInt precision (n suffix in the numbers used) otherwise we would have the same limitation Excel has loosing precision. Working with BigInt numbers, there is no precision limitation. Finally, we convert the result into a string so the output will be as text data type.

If the function was defined, for example in the LIB Snippet, then you can invoke it as follows:

=SCRIPTLAB.LIB.FIB(10000)

It returns the correct result in less than 2 secs! I tested also for 100K Fibonacci number with similar execution time, so it a scalable solution.

Here is the output for Fibonacci number 100: