Coding · Spreadsheets

Fix a Spreadsheet Formula That Shows an Error

Find out why your formula shows #N/A, #VALUE! or a wrong number, and get a corrected version.

Prompt Code output

My spreadsheet formula is not working. Here is the formula: [FORMULA]. Instead of the result I expect, I see: [WHAT_I_SEE]. What I wanted it to do is: [EXPECTED_RESULT]. Please explain in simple words what is going wrong, step by step, without assuming I know spreadsheet terms. Then give me a fixed formula I can paste over the old one. If the problem might be in my data (for example numbers stored as text, extra spaces, or empty cells), tell me how to spot that and how to fix it by hand. End with one tip to avoid this kind of error next time.

Fill in the brackets

[FORMULA]
Copy the formula from the formula bar, e.g. =VLOOKUP(A2,Sheet2!A:B,2,FALSE)
[WHAT_I_SEE]
The error or wrong value, e.g. #N/A or 0
[EXPECTED_RESULT]
e.g. show the price of each product from the price list

How to use

  1. Copy the prompt.
  2. Replace the text inside [BRACKETS] with your own details.
  3. Paste it into ChatGPT or another AI assistant.
  4. Read the result and ask for changes if needed.

Tip: Copy the formula from the formula bar at the top, not from the cell, so the AI sees the full text.