/fixformula

Helps find why a formula fails and suggests a fix.

The full prompt

/fixformula This formula is not working in [Excel or Google Sheets]: [paste formula]. The error or wrong result is: [error]. My data looks like: [columns and what they hold]. Explain the most likely cause in plain words, give the corrected formula, and list other causes to check if that does not fix it.

Replace the highlighted [brackets] with your own details, then send.

What you're asking

You ask the AI to diagnose a broken formula. You get the likely cause, a fixed formula, and other things to check.

Give it

  • The exact formula
  • The error message or wrong result
  • What your columns hold
  • Excel or Sheets

Filled-in example

/fixformula This formula is not working in Excel: =VLOOKUP(A2,B:C,3,0). The error or wrong result is: #REF!. My data looks like: column B has employee IDs, column C has names. Explain the most likely cause in plain words, give the corrected formula, and list other causes to check if that does not fix it.

Use it in any AI chat. The slash word is a label, not a built-in command; the prompt does the work, and answers vary by app. How these work