It seems Microsoft
has no idea.
Microsoft Excel is testing a new AI-powered function that can automatically fill cells in your spreadsheets, which is similar to the feature that Google Sheets rolled out in June. You would use the “COPILOT” function followed by a natural language prompt and (optionally) specify the cells you want it to reference; the AI would then classify information, generate summaries, create tables, and more.
...
The COPILOT function comes with a couple of limitations, as it can’t access information outside your spreadsheet, and you can only use it to calculate 100 functions every 10 minutes. Microsoft also warns against using the AI function for numerical calculations or in “high-stakes scenarios” with legal, regulatory, and compliance implications, as COPILOT “can give incorrect responses.”
I always thought that "adding up stuff, correctly" was a core function. I guess I was wrong!