该提示词用于生成Excel公式，使A2单元格依据A1的数字，在向下拖动时产生“若干0后接一个1”的循环序列。适用于Excel数据处理、排班表与周期循环场景。

中文版提示词

在Excel中，单元格A1是一个数字，例如12。我需要你在A2写一个公式，向下拖动时按照A1的数据生成“0-1”循环：当A1=12时，A1至L2单元格的数据为0,0,0,0,0,0,0,0,0,0,0,1，继续往后拖动也是0,0,0,0,0,0,0,0,0,0,0,1，不断循环。若A1=6，则循环数列为0,0,0,0,0,1，以此类推。请给出公式。

英文版提示词

In Excel, cell A1 contains a number, for example 12. I need you to write a formula in A2 so that, when dragged down, it generates a repeating "0-1" cycle based on A1: when A1=12, cells A1 through L2 are 0,0,0,0,0,0,0,0,0,0,0,1, and dragging further also repeats 0,0,0,0,0,0,0,0,0,0,0,1. If A1=6, the cycle is 0,0,0,0,0,1, and so on. Please provide the formula.

🛠️ **适用 AI 工具**：Claude、ChatGPT、Copilot、DeepSeek、Gemini、Kimi