Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, ...
You can also use other Excel functions in IF statements to perform calculations. IF statements in Excel are my secret sauce for transforming spreadsheets into intelligent decision-making tools.