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.