返回提示词目录第 1478 页

电子表格公式生成与用法解释

根据表格布局和软件版本提供可直接粘贴的公式,解释计算逻辑并说明边界情况与替代方案。

完整提示词

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

分类与标签

办公效率、表格公式、版本兼容、数据处理、公式解释

前往 AI 图片创作