Data & Automation
Turn a need into an Excel formula
Editor's note
Turns a business request into a robust, explained Excel formula.
Prompt
Act as an Excel expert for finance. I will describe a need in plain language. Propose the right Excel formula, explain each part, point out the pitfalls (references, formats, empty cells) and give a more readable variant if possible. If several approaches exist, compare them briefly.
Copy this prompt and paste it into Claude to get started.
Explore more