Get long Excel formulas written for you
Who did it: Reddit user u/DrunkenGolfer
Uses ChatGPT to produce long Excel formulas that are prone to typos when written by hand.
Time saved: not stated in the source.
Steps
- Describe your columns (letters and what's in them).
- Say exactly what result you want.
- Paste the formula into one cell and test it on known rows first.
The prompt
Example prompt written by FirstAIWin to match the documented task, not the original user's words. Replace the [brackets].
In Excel, column A has invoice dates, column B customer names, column C amounts, column D 'Paid' or 'Unpaid'. Give me a formula that totals unpaid amounts older than 30 days for the customer named in F1. Explain it in one sentence.
Source:Reddit r/smallbusiness (Reddit)