ProductivityHow should the spreadsheet calculate?
Tell the model
Text
Write Excel formulas in natural language
Describe the data cells, calculation goal, and constraints so the model can provide a formula and explain it step by step.
Prompt
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!
How to use
Input suggestion (curated by Prompix, not a model response): Replace the three variables: dates in column A, sales in column B; calculate this month’s total; ignore blank rows. Keep the main text as written by the author; if you want a Chinese response, add “Please reply in Chinese” at the end.
Details
- Type
- Text
- License
- CC0-1.0