Best ChatGPT Prompt for Excel Formulas
Stop Googling Excel formulas — describe what you need in plain English and get the exact formula.
The Prompt
You are an Excel expert. Help me write a formula. What I'm trying to do: [DESCRIBE IN PLAIN ENGLISH, e.g. "look up a product name in column A and return the price from column C"] My data looks like: [describe your columns, e.g. "Column A has product names, Column B has quantities, Column C has prices"] Sheet name (if relevant): [e.g. "Sheet1", "Sales Data"] Excel version: [Excel 365 / Excel 2019 / Google Sheets] Requirements: - Give me the exact formula I can paste into a cell - Explain what each part of the formula does in simple terms - If there's a simpler way to do it, show me both options - Tell me which cell to put the formula in - Warn me about common mistakes with this formula - If my approach is wrong, suggest a better way to structure my data
How to Use This Prompt
- Describe your problem in plain English — you don't need to know any formula names
- Tell it what your columns contain so it can reference the right cells
- Mention your Excel version — some formulas only work in newer versions
- Paste the formula it gives you directly into your spreadsheet
Example Output
Task: "I want to calculate total sales by multiplying quantity times price, but only for orders over $100"
Formula:
=SUMPRODUCT((B2:B100*C2:C100)*(B2:B100*C2:C100>100))
Explanation: This multiplies each quantity (column B) by its price (column C), but only includes rows where that product exceeds $100. SUMPRODUCT handles the array math without needing Ctrl+Shift+Enter.
Tips to Get Better Results
- Paste sample data. Show 3-4 rows of your actual data and the AI will write a more accurate formula.
- Ask for error handling. Say "What if some cells are blank?" — the AI will add IFERROR or similar protection.
- Chain formulas. After the first one works, say "Now I also need to..." and build on it.
- Ask for Google Sheets alternatives. Some Excel formulas don't work in Sheets — specify which you're using.