Back to guide/General Productivity

Formula Generator

Describing the exact column layout prevents the AI from guessing your data structure. Specifying edge cases upfront avoids formulas that break on real data. The 'simplest function' instruction prevents over-engineered solutions.

chatgpt-prompts-for-excelwhat_you_want_to_calculatecolumn_a_descriptioncolumn_b_description

Edit View

Prompt

I need an Excel formula for this task:

**Goal:** {{what_you_want_to_calculate}}
**Data layout:**
- Column A: {{column_a_description}}
- Column B: {{column_b_description}}
- Column C: {{column_c_description}}
**Data starts at row:** {{start_row}} (e.g., row 2, with headers in row 1)
**Total rows:** approximately {{row_count}}

**Edge cases to handle:**
- {{edge_case_1}} (e.g., "blank cells should be skipped")
- {{edge_case_2}} (e.g., "duplicates should return the first match")

Provide:
1. The formula
2. A brief explanation of how it works
3. Paste it into cell: {{target_cell}}

Use the simplest function that works. Prefer INDEX-MATCH over VLOOKUP. If XLOOKUP is available (Excel 365), mention that as an alternative.

Variables to customize

{{what_you_want_to_calculate}}{{column_a_description}}{{column_b_description}}{{column_c_description}}{{start_row}}{{row_count}}{{edge_case_1}}{{edge_case_2}}{{target_cell}}

Why this prompt works

Save this prompt to your library

Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.

Related prompts

Task Decomposition Agent

Forcing the agent to plan before acting prevents premature execution and wasted steps. Explicit dependency mapping enables parallel execution and catches logical gaps early.

Tool Selection Agent

The ReAct pattern (Reason + Act) creates an explicit reasoning trace that improves tool selection accuracy. The error-handling rule prevents infinite retry loops.

Prompt Compressor

Explicitly requiring all functional requirements to be preserved prevents the model from over-compressing and losing critical instructions.

Memory Management Agent

Explicit memory read/write instructions create agents that improve over time. Categorization keeps memories organized, and the deduplication rule prevents context bloat.