=SOLVE(problem, faster)
Solve spreadsheet problems, faster.
Find, fix, and understand Excel and Google Sheets formulas for real work — every one tested with sample data and explained in plain English.
Tested, not generated
Every formula is executed against real sample data before publishing.
Plain English
Each argument explained — no jargon walls, no guesswork.
Both platforms
Excel and Google Sheets versions, with the differences called out.
Start with the workhorses
All formulas →Calculate CAGR (Compound Annual Growth Rate)
One formula turns a start value, end value, and number of years into the steady annual growth rate — the honest way to compare growth.
=(B2/A2)^(1/C2)-1Calculate Return on Investment (ROI)
Divide the gain by what you put in — (return − cost) / cost — to see how hard each dollar worked, as a clean percentage.
=(B2-A2)/A2Calculate Gross Profit and Gross Margin
Revenue minus cost of goods gives gross profit in dollars; divide by revenue and you have the margin percentage in the next column.
=B2-A2Calculate Simple Interest on a Loan
Principal × rate × years gives the interest a simple-interest loan charges, and one more step gives the total you'll repay.
=A2*B2*C2Calculate Average Order Value (AOV)
Divide total revenue by the number of orders to get AOV — with an IF guard so months with zero orders don't blow up in #DIV/0!.
=B2/C2Calculate Customer Churn Rate
Customers lost divided by customers at the start of the period gives your churn rate — and 1 minus churn gives retention.
=B2/A2Skip the blank grid
Trackers with the formulas already wired in — download, replace the sample rows, done.
Sales Pipeline Tracker
Track every deal by stage with probability-weighted values, open-pipeline and won totals — the whole funnel on one sheet.
.xlsx · freeBudget Tracker
Budget vs. actual by category with variance in dollars and percent, plus totals — negative variance shows in red automatically.
.xlsx · freeInvoice Tracker
Log invoices with automatic due dates from payment terms, days-overdue tracking, and an outstanding-balance summary.
.xlsx · freeBrowse by problem
10 of 10 categories live · new formulas added weekly
One useful formula in your inbox.
Tested formulas, templates, and fixes — about twice a month. No filler.