Everyday AI · Work & business
Fix an Excel or Google Sheets formula
Is your spreadsheet showing an error or you do not know which formula to use?
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.
I am using [Microsoft Excel / Google Sheets].
I need a formula that calculates [what you want done].
Here is my sheet layout:
- Column A: [e.g. Product Name]
- Column B: [e.g. Unit Price]
- Column C: [e.g. Quantity Sold]
- Column D: [Where I want the result]
Give me:
1. The exact formula to paste into cell D2.
2. A simple 1-sentence explanation of how it works.
3. What to do if it returns an #N/A or #VALUE error.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.