You can use ChatGPT to write Excel formulas, explain what a formula does, fix an error, or suggest the right function for a task. The key is to describe your data clearly: which columns hold what, and exactly what result you want. ChatGPT then gives you a formula you paste into Excel. It's like having a formula expert on call, as long as you test what it gives you on your own sheet.
How to ask ChatGPT for a formula
Tell it three things: your columns, your goal, and where the answer should go. For example:
"In Excel, column A has product names and column B has sales amounts. Write a formula to add only the sales where the product is 'Pen'."
ChatGPT replies with something like =SUMIF(A:A,"Pen",B:B) and explains it. You paste it in, adjust the ranges, and you're done.
Copy-ready prompts
| Goal | Prompt to use |
|---|---|
| Write a formula | "In Excel, column A is names and B is marks. Write a formula to show Pass if marks are 33 or more, else Fail." |
| Fix an error | "My Excel formula =VLOOKUP(E2,A:C,3) returns #N/A. What's wrong and how do I fix it?" |
| Explain a formula | "Explain what this Excel formula does in simple words: =INDEX(B:B,MATCH(E2,A:A,0))." |
| Choose a function | "In Excel I want to count how many orders are above ₹1000. Which function should I use and how?" |
| Clean data | "Give me an Excel formula to remove extra spaces from the text in column A." |
| Make steps | "Give step-by-step instructions to make a pivot table from sales data in Excel." |
Worked example
You have a sheet where column C is City and D is Amount. You want the total for Delhi. You type:
"In Excel, column C has cities and column D has amounts. Write a formula to total the amounts only for 'Delhi', and explain it."
ChatGPT returns =SUMIF(C:C,"Delhi",D:D) with a one-line explanation. You paste it, and it works. If your data starts at row 2, you can tighten it to =SUMIF(C2:C100,"Delhi",D2:D100).
Always test the formula
ChatGPT sometimes gives a formula that's close but not perfect for your exact layout. Before trusting it:
- Paste it into a copy of your sheet.
- Check the answer against a small example you can verify by hand.
- Adjust the cell ranges to match your data.
Pro tips
- Mention your Excel version if it matters (XLOOKUP needs Excel 2021/365).
- Give a tiny sample of your data in the prompt; it helps ChatGPT match your layout.
- Ask "explain this formula" for anything you don't understand, so you actually learn it.
Common mistakes
- Pasting a formula without checking ranges. ChatGPT may use
A:Awhen your data isA2:A50. Adjust it. - Trusting the result blindly. Verify against a known answer, especially for money.
- Vague prompts. "Help with Excel" gives nothing. Describe the columns and the goal.
Key takeaways
- Describe your columns and your goal; ChatGPT writes the formula.
- Use it to write, fix, explain and choose Excel functions.
- Always test the formula on a copy and adjust the ranges.
- Ask it to explain formulas so you learn, not just copy.
Practice task
Open any sheet with a text column and a number column. Ask ChatGPT to write a formula that averages the numbers for one specific category. Paste it in, check the answer by hand, and fix the ranges if needed.
Combine Excel and AI the smart way in the ADCA (AI Integrated) program at HCI.
Frequently Asked Questions
Can ChatGPT write Excel formulas?
Yes. Describe your columns and what you want, and ChatGPT writes a formula you can paste into Excel, usually with an explanation.
How do I ask ChatGPT for an Excel formula?
State which columns hold what, the result you want, and where it should go. For example, "column A is names, B is marks, write a Pass/Fail formula."
Can ChatGPT fix my Excel errors?
Yes. Paste your formula and the error (like #N/A), and ask what's wrong. It explains the cause and gives a corrected version.
Is the formula from ChatGPT always correct?
Not always. It can get the ranges or logic slightly wrong for your layout, so test it on a copy and check against a known answer.
Do I still need to learn Excel if ChatGPT can help?
Yes. You need to understand the formula to check it and adjust it. ChatGPT speeds you up; it doesn't replace knowing the basics.