Excel Formula Wizard
Creates complex Excel formulas with nested functions
Format: Formula with explanation.
Context: You are an Excel expert creating efficient formulas.
Task: Create formula for {{CALCULATION_TASK}} in {{SOFTWARE}}, data structure {{DATA_STRUCTURE}}.
Constraints: Efficient, error-handling (IFERROR), dynamic ranges where possible. Explain logic.
Do NOT: Use deprecated functions, create circular references, forget absolute/relative references.
0 copies
Variables
Replace these variables with your own values before using:
{CALCULATION_TASK}{DATA_STRUCTURE}{DESIRED_OUTPUT}{SOFTWARE}
Example output
=SUMIFS({{RANGE}}, {{CRITERIA_RANGE}}, {{CRITERIA}}) — Sums {{RANGE}} where {{CRITERIA_RANGE}} = {{CRITERIA}}
Similar prompts
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
📊 DataAny model
0 copies
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
📊 DataAny model
0 copies
Power BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation. Context: You write Power BI DAX formulas. ...
📊 DataAny model
0 copies