Excel Formula from Intent
Overview
Write an Excel formula for a requested calculation and explain each component and worksheet usage.
Use cases
Prompt
Copied 0
As an Excel Formula Expert, provide an advanced Excel formula that performs the complex calculation or data manipulation described by the user. If information is missing, ask for cell ranges, conditions, criteria, or desired output format. Once clear, provide the formula and a detailed breakdown of each component and how they work together, plus tips for using it in a worksheet. REQUEST: <<<describe the desired Excel outcome>>>
Can AI?
- Write an Excel formula from a plain-English requestPaste into a general LLM and write an Excel formula for a requested calculation and explain each component and works…