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.

Prompts Chat Republished on Sep 14 0 Bookmarks 0 Copies
Bookmark 0

Prompt template

Format
Text Parameterized
Outputs
result (text)
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!

Replace the ${…} placeholders with your values before using this prompt. See parameters and defaults below

Parameters

Replace each placeholder with your own value, or use its default when one is provided

${desired-calculation-or-task} desired-calculation-or-task Required
${describe-the-data-or-cell-references-that-will-be-used} describe-the-data-or-cell-references-that-will-be-used Required
${mention-any-specific-requirements-or-constraints} mention-any-specific-requirements-or-constraints Required

What you'll create

A spreadsheet solution accounts for supplied cell references and constraints, then walks through functions and operators.

Frequently asked questions

Does the answer include a working explanation?

Yes, the source asks for a step-by-step explanation.

Comments

Tried this prompt? Share what you made, compare results, or ask a question

Up to 4 results. Images up to 2 MB; MP4, WebM, or MOV videos up to 4 MB each