Excel Formula Sensei
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!
fill the variables
This prompt has 3 variables. Pro fills them into a ready-to-paste prompt for you — no manual find-and-replace.
{desired_calculation_or_task}{describe_the_data_or_cell_references_that_will_be_used}{mention_any_specific_requirements_or_constraints}
Unlock with Pro →when to use it
Community prompt from the open-source awesome-chatgpt-prompts library (CC0 public domain). A proven "Excel Formula Sensei" starting point — swap in your own specifics and constraints. Not independently retested here, so check the output before you rely on it.
tags
educationcommunitygeneral
source
awesome-chatgpt-prompts · CC0 1.0 (public domain)