Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

Put a cell reference to B4, the monthly payment formula, in cell E3. See these inputs in the screenshot below. Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within ...

While Microsoft Excel's comments and notes tools both let you annotate a cell, they serve different purposes, work in diverse ways, and vary in how they look on a printed Excel worksheet.