Is your spreadsheet showing an error or you do not know which formula to use?

Write down what column A and column B contain, and what number or text you want to find or calculate. Paste the prompt below into your AI assistant. Mention whether you are using Microsoft Excel or Google Sheets. Copy the formula into your sheet and test it on 3 rows before applying it to the entire column. Before you use it: Test with sample data first. Verify column letters match your actual spreadsheet.

Fix Excel and Google Sheets formulas with AI

Quick answer

Tell the AI whether you use Excel or Google Sheets, what each column holds and the exact result you want, and paste any error such as #VALUE! or #N/A. Ask for the formula plus a one-line explanation. Test it on three rows you can check by hand before copying it down the whole column.

Listen to this guide

AI narration · English · Prompt text stays on the page

Try ElevenLabs ↗ · Affiliate link

A closed laptop, a ruler, and unmarked graph paper, shown in Pinoy AI Works artwork

What to do

Write down what column A and column B contain, and what number or text you want to find or calculate.
Paste the prompt below into your AI assistant. Mention whether you are using Microsoft Excel or Google Sheets.
Copy the formula into your sheet and test it on 3 rows before applying it to the entire column.

Try this prompt

Specify which spreadsheet app you use so the AI gives the exact formula syntax.

Help me diagnose and fix this spreadsheet formula. Do not guess my sheet structure.

APP
[Excel / Google Sheets]
What I want the formula to do: [PLAIN-LANGUAGE GOAL]
Current formula: [PASTE EXACT FORMULA]
Error/result I see: [ERROR OR WRONG RESULT]
Relevant cells/ranges with sample values:
[CELL/RANGE = VALUE]
Locale clues if relevant: [decimal comma/semicolon separators / unknown]

PROCESS
1. Restate what you think the formula is supposed to calculate.
2. Inspect the formula for syntax, references, ranges, data types and common logic errors.
3. If you need a missing column/range/header/value to know the correct fix, ask for it or mark “To confirm”; do not invent a sheet layout.
4. Give the smallest corrected formula first.
5. Explain exactly what changed and why.
6. Show a tiny test using only the sample values I supplied and the expected result.
7. Mention whether the formula is Excel-specific, Google-Sheets-specific, or portable.

RULES
- Preserve absolute/relative references unless changing them is necessary and explained.
- Do not invent named ranges, sheet names, columns or data.
- Do not suggest destructive edits to the workbook.
- If multiple fixes are plausible, explain what evidence distinguishes them.

End with a verification checklist I can run on one normal row, one blank/missing row and one edge case.

See a sample result

Illustrative example. Your answer may differ.

Task: Match product prices from another tab. Result: =XLOOKUP(A2, 'Price List'!A:A, 'Price List'!B:B, "Not Found") with cell-by-cell explanation.

Before you use it: Test with sample data first. Verify column letters match your actual spreadsheet.

Philippine notes

Useful for computing sales commissions, inventory reorders, and student grade averages.

Start with the basics Source & background

More everyday guides

Browse all 70 guides →