Back to browse

Excel Formula Sensei

analysisclaudegpt4gemini

Generates detailed Excel formulas for a specified calculation, data range and constraints, with explanations.

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!

Imported from the original source by fka, licensed CC0-1.0.

Are you the author and want this removed or changed? Request removal