You don’t need to memorise Excel functions. Describe what you want in plain English, and an AI chatbot will write the formula. The trick is describing your sheet clearly.

How to ask

Tell the AI: which columns hold what, which row data starts on, your Excel version, and the result you want.

“In Excel 365, column B has student names from B2, column C has exam scores out of 100. In column D, give the WASSCE-style grade: 75+ A1, 70–74 B2, 65–69 B3, 60–64 C4, 55–59 C5, 50–54 C6, 45–49 D7, 40–44 E8, below 40 F9.”

Example formulas

TaskFormula
Total sales in C2:C100=SUM(C2:C100)
Sales above GH₵1,000 count=COUNTIF(C2:C100,">1000")
Total for one product (A) “Rice”=SUMIF(A2:A100,"Rice",C2:C100)
Find price of item in E2 from list A:B=XLOOKUP(E2,A:A,B:B,"Not found")
Days until due date in B2=B2-TODAY()
Pass/Fail at 50=IF(C2>=50,"Pass","Fail")

Check every formula

  1. Test on a few rows where you know the answer.
  2. Ask the AI to “explain this formula step by step”.
  3. If you get #NAME? or #VALUE!, paste the error back to the AI.
  4. If your Excel uses ; instead of , (regional settings), tell the AI.

Built-in AI

  • Copilot in Excel (Microsoft 365 plans that include it).
  • Gemini in Google Sheets (eligible Google Workspace/Google One plans).
Don’t paste customer phone numbers, salaries or Ghana Card numbers into public AI tools. Describe the columns instead.

Checked on 10 November 2026. AI tools and app menus change often.

Common questions

Can ChatGPT write Excel formulas?

Yes. Describe your columns and what you want, and it writes the formula and explains it.

Does Excel have built-in AI?

Microsoft 365 Copilot in Excel and Gemini in Google Sheets (on eligible plans) can suggest formulas and analyse data.

Why does the AI formula give an error?

Usually wrong cell references, a different Excel version, or regional settings using ; instead of ,. Tell the AI the error message.

Is it safe to paste my spreadsheet into AI?

Remove names, phone numbers and other personal data first, or describe the columns instead.

Sources