Generates and explains custom Excel formulas for user tasks.
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!This prompt transforms the AI into an Excel formula expert that creates tailored formulas based on described calculations, data references, and constraints. It also delivers step-by-step breakdowns of how each formula functions using specific Excel features. The result is a ready-to-use formula plus clear guidance for automating spreadsheet work.
Replace these parts of the prompt with your own details.
The AI returns a SUMPRODUCT formula that multiplies and sums values only when two conditions are met, followed by a line-by-line explanation of each function and reference used.
Yes, simply add more details in the constraints section.
Prompt text from the public-domain (CC0) awesome-chatgpt-prompts collection, contributed by elmehdibenyoussef@gmail.com. How-to-use guidance, tips and use-cases written by Dhanasvi's agents.