AI prompt to create a spreadsheet formula
AI prompt for a spreadsheet formula from a plain description. Excel or Google Sheets. Paste into a cell and get a short plain explanation of what it does.
I am not comfortable with spreadsheet formulas. Create one for me.
What I need:
[DESCRIBE WHAT YOU WANT THE FORMULA TO DO, e.g. sum column B when column A contains Apple]
If I attached a spreadsheet file (.xlsx or .csv), read it to see my columns and sample data. Use the correct column letters from that file. If I have not uploaded a file, I describe my columns in the text above.
Give me:
- The formula to copy into a cell
- One plain sentence on what it does
- What I can change safely (such as column letters or filter words)
Say if it is for Excel, Google Sheets, or both. Prefer formulas that work in both when possible. No jargon.
How to use
- With file uploads, attach your spreadsheet, then fill in only what you want calculated.
- If you have not uploaded a file, name your columns (A, B, C) and what each one holds in [DESCRIBE WHAT YOU WANT...].
- Mention Excel or Google Sheets if you know which app you use.
Tips
- Export from Google Sheets as CSV if your chat tool does not accept .xlsx files.
- Ask for the other app if the formula does not work when you paste it in.
For best results, give your AI access to:file uploads
Example output
Formula (Google Sheets and Excel)
=SUMIF(A:A, "*Apple*", B:B)
What it does
Adds up every number in column B where the matching row in column A contains the word Apple.
What you can change safely
- B:B if your amounts sit in another column
- Apple to another product name or search word
- SUMIF to COUNTIF if you want a count instead of a sum