BestPromptFinder

Excel / Google Sheets Formula From One Sentence

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

I need a formula, not a lesson. Here is what I am trying to work out: [one sentence, for example how much each person still owes after these payments]. The sheet is [Excel or Google Sheets]. Columns I already have: [for example A is name, B is amount paid, C is date]. Write one formula I can paste into [cell, for example D2]. Tell me which cells it reads, and what to change if my data starts on another row. If it needs a helper column, say so and give me that formula too. Use only functions that exist in [Excel 365 or Google Sheets]. If you are not sure a function exists there, give me a longer version that definitely does. Then show it working on this tiny example, with the numbers filled in: [three rows]. If my real sheet has blanks, treat a blank as zero and do not throw an error. Do not build me a whole workbook. Do not switch me to Python. If my ask is ambiguous, ask one question, then still give the formula that matches your best guess and label that guess.

Why this prompt

• Hand-picked, editorially reviewed prompt
• Written for ChatGPT, Claude, Gemini

Source

Created by BestPromptFinder — editorial prompt, not user-generated. See our content & source policy.

Related Productivity prompts