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

1. Describe your columns (letters and what's in them).
2. Say exactly what result you want.
3. 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)