Calculate tiered commission
Создание 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.”
Примеры
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
Примеры 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 Оплачено.”
Сумма sales by city
Turn messy reporting requests into precise spreadsheet logic.
“Сумма revenue in column D where city in column B equals New York and date is in the current month.”
Исправить a #VALUE! formula
Use this when a spreadsheet already exists and the logic is failing.
“Объяснить 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
Найти дубликаты
Tells AI the job
Location
Column B
Targets the data
Результат
Highlight or label
Defines the result
More categories
Примеры beyond formulas.
Resources should also encourage deeper product usage across the rest of ЛистWise.
Создание business documents
Ask ЛистWise to build invoices, budgets, payroll workbooks, expense logs, or full spreadsheet templates from a plain-English description.
Explore Создание →Ask questions about uploaded data
Загрузка a workbook and ask for top performers, missing values, comparisons, trends, suspicious numbers, or chart recommendations.
Open AI-ассистент по данным →Создать spreadsheet automation
Describe a macro or Apps Script workflow and ask for code, setup steps, explanations, and optimization suggestions.
Open Автоматизация →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 Листs, 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.
Примеры are only valuable when they lead directly into action—so each section sends users back into the correct ЛистWise tool.