Calculate tiered commission
Create a formula or explanation for sales commission rules with multiple thresholds.
“Calculate 5% commission up to $5,000, 7% from $5,001 to $10,000, and 10% above $10,000 for the value in D2.”
Examples
Use better prompts and get better spreadsheet results.
This example library shows practical prompt patterns for formulas, reporting, invoices, data cleanup, analysis, charts, and conversions. Copy the idea, adapt it to your sheet, and use it in the main workspace.
✓ Real use cases✓ Prompt wording examples✓ Internal links to related tools
Prompt gallery
Examples users can actually adapt.
The best examples are concrete, not generic. Each one tells the AI what the business goal is, what data to use, and what the final result should look like.
Find an employee by ID
Use a formula example when your data lives on a separate sheet.
“Return the employee name and department from the Employees sheet using the ID in A2.”
Find duplicate emails
Useful for cleanup, CRM imports, and customer-list maintenance.
“Mark duplicate email addresses in column B, but ignore blank cells.”
Highlight overdue invoices
Ask for a formula, workbook logic, or document-ready rule.
“Show Overdue when the due date has passed and the invoice status is not Paid.”
Sum sales by city
Turn messy reporting requests into precise spreadsheet logic.
“Sum revenue in column D where city in column B equals New York and date is in the current month.”
Fix a #VALUE! formula
Use this when a spreadsheet already exists and the logic is failing.
“Explain why this formula returns #VALUE! and give me a corrected version.”
Visual prompt structure
What a strong example prompt contains.
Prompt part
Example
Why it matters
Goal
Find duplicates
Tells AI the job
Location
Column B
Targets the data
Output
Highlight or label
Defines the result
More categories
Examples beyond formulas.
Resources should also encourage deeper product usage across the rest of SheetWise.
Create business documents
Ask SheetWise to build invoices, budgets, payroll workbooks, expense logs, or full spreadsheet templates from a plain-English description.
Explore Create →Ask questions about uploaded data
Upload a workbook and ask for top performers, missing values, comparisons, trends, suspicious numbers, or chart recommendations.
Open AI Data Assistant →Generate spreadsheet automation
Describe a macro or Apps Script workflow and ask for code, setup steps, explanations, and optimization suggestions.
Open Automation →Can I copy these prompts exactly?
Yes, but it is even better to adapt them to your own workbook, column names, rules, and output needs.
Are the examples for Excel only?
No. Many prompt structures also work for Google Sheets, especially in formula generation, analysis, and business-document creation.
Why are examples important for SEO and conversions?
They answer real user intents, help people discover use cases, and demonstrate product value with concrete, readable content.
Where should I go after reviewing examples?
Open the matching tool page or the main workspace and try the prompt there.
Practice with real examples
Open the workspace and try a prompt that matches your job.
Examples are only valuable when they lead directly into action—so each section sends users back into the correct SheetWise tool.