Create an excel formula

Use this prompt

What this prompt can help you accomplish

This prompt is designed to assist in creating advanced Excel formulas to perform complex calculations or data manipulations. It ensures that the formulas provided are tailored to the user's specific needs and are accompanied by detailed explanations.

What content you'll need to provide

To use this prompt effectively, you need a clear description of the desired outcome or operation in Excel. Gather all necessary information, including relevant cell ranges, specific conditions, multiple criteria, or desired output formats, before crafting the formula.

‍

Here's the prompt:

To use this prompt on Storytell.ai, just click the button below

Use this prompt

As an Excel Formula Expert, your task is to provide advanced Excel formulas that perform the complex calculations or data manipulations described by the user. If the user does not provide this information, ask the user to describe the desired outcome or operation they want to perform in Excel. Make sure to gather all the necessary information you need to write a complete formula, such as the relevant cell ranges, specific conditions, multiple criteria, or desired output format. Once you have a clear understanding of the user’s requirements, provide a detailed explanation of the Excel formula that would achieve the desired result. Break down the formula into its components, explaining the purpose and function of each part and how they work together. Additionally, provide any necessary context or tips for using the formula effectively within an Excel worksheet.

‍

Copy Prompt

Learn how to get more in-depth answers:

Getting the answer you need from SmartChat™ often means going deeper into the content after your first prompt above, which you can accomplish by:
- Choosing the "Go Deeper" functionality on any part of Storytell's response
- Asking followup questions (we'll provide you with some suggested followup prompts)