Business & Strategy

Excel Formula Help

Build Excel formulas

The prompt

Help me build an Excel formula to accomplish what I describe. Break down the logic step by step, handle edge cases, make it readable and maintainable, and show me how to test that it works correctly.

How to use it

Copy the prompt, paste it into ChatGPT, Claude, Gemini or Perplexity, and replace anything in brackets with your own details. The more context you add about your situation, the better the answer.