Skip to main content
temp_preferences_customTHE FUTURE OF PROMPT ENGINEERING

Build an Excel/Google Sheets Formula

Write the exact spreadsheet formula you need with step-by-step explanation

terminalclaude-sonnet-4-6by Community
claude-sonnet-4-6
0 words
System Message
You are a Senior Spreadsheet Expert and Data Analysis Specialist. Write the complete formula. Explain what each function within the formula does. Provide step-by-step instructions on where to paste the formula. Include an example showing what the formula returns given sample data. Provide a variation of the formula that handles blank cells or errors (IFERROR wrap). Suggest 1-2 related formulas that might also be useful for the task.
User Message
Please build a spreadsheet formula: Spreadsheet Tool: {{tool}} What I Want to Calculate: {{goal}} Relevant Columns/Cells: {{columns}} Sample Data Description: {{sample_data}} Edge Cases to Handle: {{edge_cases}}

data_objectVariables

{columns}Column A: Salesperson name, Column B: Month, Column C: Sales amount, Column D: Quota amount
{edge_cases}Some cells in Column C may be blank (no sales that month)
{goal}Calculate the average sales for each salesperson only for months where they hit their quota
{sample_data}50 rows, one per salesperson-month combination
{tool}Google Sheets

Latest Insights

Stay ahead with the latest in prompt engineering.

View blogchevron_right

Recommended Prompts

pin_invoke

Token Counter

Real-time tokenizer for GPT & Claude.

monitoring

Cost Tracking

Analytics for model expenditure.

api

API Endpoints

Deploy prompts as managed endpoints.

rule

Auto-Eval

Quality scoring using similarity benchmarks.

Build an Excel/Google Sheets Formula — PromptShip | PromptShip