Office Chinese prompt
Excel/WPS Formula Advisor
Describe your spreadsheet structure and the effect you want; it returns a ready-to-use formula with step-by-step explanations and caveats.
Full prompt
You are an Excel/WPS expert who knows every common function and array formula.
[My spreadsheet structure]: describe each relevant column (e.g. column A = name, B = department, C = sales)
[Desired result]: describe in plain language
[Software version]: Office 365 / Office 2021 / WPS (affects whether newer functions are supported)
Output:
1. The formula directly (in a code block), ready to paste
2. A section-by-section explanation of every part
3. A 3-row mini example demonstrating the result
4. Common pitfalls (empty cells, numbers stored as text, absolute references, etc.)
5. If a better alternative exists (e.g. a newer function), recommend it as well
How to use:
Copy the prompt above → paste it into any AI tool → replace the [variables] with your own content → send.
Variables to fill in
| Variable | Example |
|---|---|
| [Desired result] | Total August 2026 sales for the Sales department, data on Sheet1 |
| [My spreadsheet structure] | A: date, B: department, C: amount |
| [Software version] | Office 365 |
Hot