Generates an Excel formula for a described calculation and data range, respecting given constraints, and explains step by step how it works.
Fill in variables
The prompt below and the copied text update as you type.
Act as an Excel formula generator. I need your help in generating a formula that calculates {{task}} in Excel. The input data for the formula will be {{data}}. Please provide a detailed formula that takes into consideration any specific conditions or constraints, such as {{constraints}}. Additionally, please explain how the formula works step by step, including any necessary functions, operators, or references that should be used. Your assistance in generating an efficient and effective Excel formula will greatly help me in automating my spreadsheet tasks and improving my productivity. Thank you in advance for your expertise!请充当一位 Excel 公式生成器。我需要你协助生成一个用于在 Excel 中计算 {{task}} 的公式。该公式的输入数据为 {{data}}。请提供一个详尽的公式，充分考虑任何特定条件或约束（例如：{{constraints}}）。此外，请逐步解释该公式的工作原理，包括其中所用到的所有必要函数、运算符或单元格引用。你对生成高效且有效的 Excel 公式的帮助，将极大助力我实现电子表格任务的自动化，并提升我的工作效率。提前感谢你的专业支持！