Description
Generate complex Excel formulas from plain English descriptions. Handles nested functions, array formulas, and dynamic references with explanations for each component of the formula.
Preview
Example Input
Need: Calculate commission based on tiered rates. 0-10K = 5%, 10K-50K = 8%, 50K+ = 12%. Sales amount in B2.
Example Output
## Excel Formula\n\n```\n=IF(B2<=10000,B2*0.05,IF(B2<=50000,10000*0.05+(B2-10000)*0.08,10000*0.05+40000*0.08+(B2-50000)*0.12))\n```\n\n**Breakdown:**\n\n1. First tier (0-10K): `B2*0.05`\n - Flat 5% on entire amount\n\n2. Second tier (10K-50K): `10000*0.05+(B2-10000)*0.08`\n - $500 (5% of first 10K)\n - Plus 8% of amount over 10K\n\n3. Third tier (50K+): Full calculation\n - $500 (tier 1) + $3,200 (tier 2)\n - Plus 12% of amount over 50K\n\n**Example Results:**\n- $8,000 sales = $400 commission\n- $30,000 sales = $2,100 commission\n- $75,000 sales = $6,700 commission
Reviews (10)
The data visualization recommendations are perfect. My reports look professional now!
Found insights in our data we never knew existed. This prompt is a treasure!
Good analysis quality. Occasionally needs methodology adjustment.
Average data output. Good starting point for analysis.
Fantastic for data storytelling. Clear visualizations and insights.
Average data output. Good starting point for analysis.
Reliable data tool. Helps with reports and presentations.
Good analysis quality. Occasionally needs methodology adjustment.
Incredible data assistant. My reports have improved significantly.
Decent for basic data analysis. Complex datasets need more work.
FREE with subscription
Learn More →- Instant download after purchase
- Lifetime access
- 30-day money-back guarantee
About the Seller
Mark-T AI
Member since Feb 15, 2025
Official Mark-T marketplace prompts. Curated collection of high-quality AI prompts for ChatGPT, Claude, Midjourney, DALL-E, Stable Diffusion, and Sora. Trusted by thousands of creators and professionals.