OfficeUpdated 2026-10-24
Excel Formula Prompt
Describe the need in plain language and get an explainable, testable Excel formula.
#Excel#公式#办公#数据处理DeepSeekKimiMicrosoft 365 Copilot
Prompt
Write an Excel formula for me.
Excel version: {{version}}
Data layout: {{columns and ranges}}
Requirement: {{requirement}}
Requirements:
1. Restate the requirement and list assumptions.
2. Give the main formula and two alternatives for older versions.
3. Explain each part.
4. Provide three test cases: normal, blank and boundary.
5. If Power Query or a pivot table is better, say so.Variables to replace
{{版本}}{{列名和范围}}{{需求}}
Example output
=SUMIFS(C:C,A:A,"East",B:B,">="&DATE(2026,1,1))
How to use it
Provide columns, ranges and version; it prevents formulas with unavailable functions.
Recommended tools
Related prompts
Office
Meeting Summary Prompt
Turn a transcript into decisions, action items and risks, not a transcript dump.
通义听悟Notion AIMicrosoft 365 Copilot
Office
PPT Outline Prompt
Turn a topic into a narrative PPT outline instead of a pile of facts.
DeepSeekKimiSlidesAI
Office
Business Email Reply Prompt
Write a clear, appropriate reply with a clear next step.
GrammarlyDeepSeekSuperhuman