Home · Business tools · Describe what you need and get the Excel formula, with a test row to prove it
Describe what you need and get the Excel formula, with a test row to prove it
You know what you want the spreadsheet to do, not the formula. Describe it in plain words and get one that works, with a check.
The prompt · ChatGPT
Write an Excel formula for me. My columns: [paste the header row and 2–3 example rows, made up if the real ones are private]
The full prompt is free – sign up in 10 seconds
Free account: every prompt, one-tap copy, saved favourites.
Already have an account? Log in
No password needed. We email you a sign-in link.
What you get (sample answer)
Put this in H2 (Microsoft 365): =IF(AND(E2<>"", TODAY()-E2>30), F2, 0) E = due date, F = amount. It shows the amount only when the invoice is more than 30 days late; otherwise 0. Test row: due date 1 Jun, amount 500, today mid-August → H2 should show 500. Common mistake: mixing text dates with real dates — format column E as Date first.
The prompt · Copilot
Write an Excel formula for me. My columns: [paste the header row and 2–3 example rows, made up if the real ones are private]
The full prompt is free – sign up in 10 seconds
Free account: every prompt, one-tap copy, saved favourites.
Already have an account? Log in
No password needed. We email you a sign-in link.
What you get (sample answer)
Put this in H2 (Microsoft 365): =IF(AND(E2<>"", TODAY()-E2>30), F2, 0) E = due date, F = amount. It shows the amount only when the invoice is more than 30 days late; otherwise 0. Test row: due date 1 Jun, amount 500, today mid-August → H2 should show 500. Common mistake: mixing text dates with real dates — format column E as Date first.
Copy your header row and a few example rows, changing anything private.
Paste the prompt above into any assistant.
Paste the formula into a copy of your sheet first.
Why it helps
You copy formulas from forums that nearly work, break the sheet, and end up totting things up by hand again.
Tools
Paste the prompt, fill the blanks, copy the draft.
- Microsoft Copilot — required. Works with the business tool named on this recipe. You stay in control of what gets sent.