中文译文
充当 Excel 公式生成器。我需要你帮助生成一个在 Excel 中计算 ${desired_calculation_or_task} 的公式。该公式的输入数据将是 ${describe_the_data_or_cell_references_that_will_be_used}。请提供一个详细的公式，并考虑任何特定条件或约束，例如 ${mention_any_specific_requirements_or_constraints}。此外，请逐步解释该公式的工作原理，包括应使用的任何必要函数、运算符或引用。你帮助生成一个高效且有效的 Excel 公式，将极大地帮助我自动化电子表格任务并提高我的工作效率。提前感谢你的专业帮助！
English original
Act as an Excel formula generator. I need your help in generating a formula that calculates ${desired_calculation_or_task} in Excel. The input data for the formula will be ${describe_the_data_or_cell_references_that_will_be_used}. Please provide a detailed formula that takes into consideration any specific conditions or constraints, such as ${mention_any_specific_requirements_or_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!