Calculate tiered commission
“Calculate 5% commission up to $5,000, 7% from $5,001–$10,000, and 10% above $10,000.”
Try this example
Examples
Sales
Lookups
Data quality
Invoices
Reporting
Errors
Real spreadsheet problems, solved clearly.
Use these prompts in the main tool, or adapt them to your own worksheet columns and rules.
Find an employee by ID
“Return the employee name and department from the Employees sheet using the ID in A2.”
Try this exampleFind duplicate emails
“Mark duplicate email addresses in column B, but ignore blank cells.”
Try this exampleHighlight overdue invoices
“Show Overdue when the due date has passed and the invoice status is not Paid.”
Try this exampleSum sales by city
“Sum revenue in column D where city in column B equals New York and date is in the current month.”
Try this exampleFix a #VALUE! formula
“Explain why this formula returns #VALUE! and give me a corrected version.”
Try this example