Fantastic Lambda function calculates American Option Pricing in one cell
Recursive Lambda creates inner and outside "loop" for option pricing
American Option Pricing without VBA
The function runs much faster than similar solution with VBA
Very good example for recursive Lambda function for complex calculations
Link to Excel file with Lambda function: https://tinyurl.com/czpv34y9