The new feature is called formula completion and it’s powered by AI models to “proactively suggest and autocomplete formulas ...

Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

Microsoft adds a new Copilot function to Excel, letting users generate, analyze, and summarize data directly in spreadsheet cells with AI.

The midpoint formula seems much more complicated, but when used in a price-demand calculation, allows for the same coefficient of elasticity regardless of whether the price is going up or going down.