Home · Business tools · Describe what you need and get the Excel formula, with a test row to prove it
Just ask 2 min
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.
Loading the outline…