Can AI do Excel formulas?
Yes. Test one row.
"I need a formula to add up sales."
"Column A is the rep's name. Column C is the sale. Add up the sales for the name in E2."
"A formula for somebody else's sheet. It errors in yours."
"=SUMIF(A:A,E2,C:C), and one line on what each part does."
An example. Your sheet, your columns.
Yes, and it's one of the things AI is best at, as long as you tell it what's in your columns. Test the formula on one row you can check by hand before you trust it on the whole sheet.
Name your columns first.
Name your columns
The letter, then what's in it.
Say it in plain words
"Add up the amounts for each name."
Test one row by hand
If the math matches, fill it down.
Paste the error back
"It says #N/A." It'll fix its own work.
Write me an Excel formula. My columns: [list each column letter and what's in it]. What I want: [say it in plain words]. Tell me which cell to put it in, explain each part in one line, and tell me one way to check it's right.
Before you paste work stuff into any AI, check what your company allows.The Formula Finder
Pick what you're trying to do, in plain words. Get the formula, what it means, and how to check it.
Find my formula
Learn this in the Lab, free
A free group where you learn to use Claude for the repeat parts of your job: email, reports, forms. Start with a 15-minute chat that maps what Claude can do in your job.
- Free
- No coding
- Works in Claude
Can AI create Excel formulas?
Yes. Describe the columns and what you want.
What is the best AI for Excel formulas?
Any of the big chat AIs can do it. A clear ask beats a fancy tool.
How do I use AI for VLOOKUP in Excel?
Tell it which sheet has the list and which column you want pulled over. It writes the lookup and explains it.
Want to hand this to Claude?
Start in the Lab with the free 9-to-5 Job Triage: a 15-minute chat that maps what Claude can do in your job. Everything inside is free.