Excel 公式生成器
根据用户提供的计算任务和数据结构,生成详细的 Excel 公式,并逐步解释其工作原理。
提示词正文
复制后可直接粘贴到模型或内部评测工具。
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!
使用场景
参考输出
公式及其逐步解释
评分维度
公式准确性,解释清晰度,效率,约束条件满足度
试用与模板
填写变量后复制,或保存到个人工作台模板。
这个模板没有变量,可直接复制使用。
用户评分
0 个评分你的评分
登录后评分
评论
0登录后评论