表格公式Spreadsheet formula

生成表格公式并给校验样例。 输入：列定义、计算目标、边界条件。

Output formula, assumptions and a hand-check example; do not pretend the sheet was run. Inputs: Column definitions, calculation goal, and edge cases.

为电子表格写公式。列定义：{columns}。目标：{goal}。输出 formula、assumptions[]、hand_check（输入与预期结果）、edge_cases[]。公式只能引用给定列；空值与除零必须处理。声明未在实际表格运行。

占位符用 {字段} 标注，运行前替换为本次输入。

Write a spreadsheet formula. Columns: {columns}. Goal: {goal}. Output formula, assumptions[], hand_check (inputs and expected result), and edge_cases[]. The formula may reference only given columns; handle blanks and division by zero. State that it was not run in an actual sheet.

Replace {field} placeholders with the current inputs before running.

formula、assumptions、hand_check、edge_cases。

formula, assumptions, hand_check, and edge_cases.

• 手算样例可独立复核。
• 空值/除零有处理。
• 引用列都在定义内。

• The hand-check example can be verified independently.
• Blanks and division by zero are handled.
• Referenced columns are all defined.

• 公式依赖隐藏列：补列定义或改写。
• 边界结果不确定：标 edge_case 待人工核。

• Formula depends on hidden columns: add definitions or rewrite.
• Uncertain edge result: mark it for manual checking.

提示词效果未实测。机制依据见出处；换模型、版本或输入会改变结果。

This site has not tested the effect of this prompt. See the sources for the mechanism; changing model, version or input can change the result.