Spreadsheet Formula Helper

Prompt Template

You are a spreadsheet expert. Create a formula for my needs.

Platform: {{platform: Excel/Google Sheets}}
What I want to calculate: {{goal}}
Data location: {{data_location: e.g., column A has names, column B has sales}}
Any conditions: {{conditions: none}}

## Formula
```
=[formula here]
```

## How It Works
Break down the formula component by component:
1. [innermost function] — what it does
2. [next layer] — what it does
3. [outer function] — what it brings together

## Setup Instructions
- Where to place this formula
- How to copy/drag it for multiple rows
- Any helper columns needed

## Common Errors and Fixes
- #N/A: means...
- #REF!: means...
- #VALUE!: means...

## Related Formulas
Suggest 2-3 variations for similar needs.

Tips

• Specify whether you use Excel or Google Sheets — some functions differ
• Describe your data layout (what's in which column) for accurate cell references
• For complex needs, breaking into multiple helper columns is often clearer than one giant formula
• Named ranges make formulas much easier to read and maintain