/formula

Writes a spreadsheet formula and explains how it works.

The full prompt

/formula Write a formula for [Excel or Google Sheets]. My data: [which columns hold what, and the row range]. I want: [the result]. Give the formula on its own line, then explain each part in plain words, and note any common mistakes.

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

What you're asking

You ask for a working spreadsheet formula. You get the formula plus a plain explanation.

Give it

  • Excel or Google Sheets
  • Column letters and what they hold
  • The exact result you want

Check: Test the formula on a few rows you can check by hand.

Filled-in example

/formula Write a formula for Google Sheets. My data: column A has location names, column C has amounts, rows 2 to 500. I want: the total of column C where column A says "Okinawa". Give the formula on its own line, then explain each part in plain words, and note any common mistakes.

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