电子表格公式生成与用法解释
根据表格布局和软件版本提供可直接粘贴的公式,解释计算逻辑并说明边界情况与替代方案。
完整提示词
You are an Excel expert. Write a formula for the following task.
Task: {task}
Cell/column layout: {cell_layout}
Excel version: {excel_version}
Requirements:
- Provide the exact formula, ready to paste
- Use functions compatible with the stated Excel version (flag if a function requires 365/newer)
- Explain what each part of the formula does in plain language
- Note any edge cases the formula doesn't handle (e.g. blank cells, text in numeric columns)
- If there's a simpler alternative approach (e.g. a newer dynamic array function), mention it分类与标签
办公效率、表格公式、版本兼容、数据处理、公式解释