#公式

Excel Formula Prompt Template: Teach the AI Your Table's Layout Before Asking for a Formula

Nine times out of ten, asking AI for a formula fails because it doesn't know what your table actually looks like. This template gives you a fill-in-the-blanks format for describing your column structure; the formula you get back comes with a step-by-step breakdown, a 5-row mini sample table, and two common gotchas flagged, with both legacy and modern function syntax provided.