Free Calculators with Excel Formulas
Each calculator gives you the answer and the Excel formula that produces it, with cell references you can paste straight into your own workbook. Search by what you need or by the Excel function you want to learn.
Free to use, no account needed. Your numbers stay in your browser.
No calculator matches that. Try a shorter word.
Loan and savings calculators
Mortgage Calculator Monthly payment with property tax, insurance and HOA included.
PMT() Loan Calculator Monthly payment, total interest and total cost for any loan. PMT() Amortization Calculator Full month-by-month schedule, with the effect of paying extra. IPMT() + PPMT() Auto Loan Calculator Car payment after down payment, trade-in, sales tax and fees. PMT() Credit Card Payoff Calculator How long your balance takes to clear at a fixed monthly payment. NPER() Compound Interest Calculator Growth of a balance with interest on interest and monthly deposits. FV() Simple Interest Calculator Interest on the original amount only, with no compounding. =P*Rate*Years Investment Calculator What regular contributions grow to at an expected return. FV() Retirement Calculator Whether your savings plan reaches the income you want. FV() Savings Goal Calculator How much to save each month to hit a target by a date. PMT() Pay Raise Calculator New pay after a percentage raise, or the raise a new offer gives you. =Pay*(1+Raise) Business and investment calculators
Future Value Calculator What a lump sum and regular payments are worth later.
FV() Present Value Calculator What future money is worth today at a discount rate. PV() Margin Calculator Profit margin from cost and price, or the price for a target margin. =(Price-Cost)/Price Markup Calculator Selling price from cost and markup, or the markup on a price. =Cost*(1+Markup) Discount Calculator Sale price and savings, including a second discount on top. =Price*(1-Off) Sales Tax Calculator Add tax to a price, or take it back out of a total. =Price*(1+Tax) Break-Even Calculator Units and sales you need before you start making a profit. =Fixed/(Price-Var) ROI Calculator Return on investment, plus the yearly rate if you add a time. =(Return-Cost)/Cost CAGR Calculator Compound annual growth rate between two values. RRI() NPV Calculator Net present value of a project's cash flows at a discount rate. NPV() IRR Calculator The rate of return that sets a project's NPV to zero. IRR() Depreciation Calculator Straight-line, double declining and sum-of-years schedules. SLN() WACC Calculator Weighted average cost of capital from debt and equity. =E/V*Re+D/V*Rd*(1-T) Statistics calculators
Standard Deviation Calculator Sample or population standard deviation and variance, with working.
STDEV.S() Average Calculator Mean of a list of numbers, with the sum, count, min and max. AVERAGE() Mean, Median and Mode Calculator All three averages and the range from one list. MEDIAN() + MODE() Weighted Average Calculator Average where some values count more than others. SUMPRODUCT() Z-Score Calculator How many standard deviations a value is from the mean. STANDARDIZE() Percentile Calculator Value at any percentile, and the percentile rank of a value. PERCENTILE.INC() Correlation Coefficient Calculator Pearson's r and R² between two lists, with the trend line. CORREL() Confidence Interval Calculator Range for the true mean from a sample, using t or z. CONFIDENCE.T() Sample Size Calculator Responses needed for a survey at a given margin of error. NORM.S.INV() Percentage, date and time calculators
Percentage Calculator X% of a number, what percent one number is of another, and more.
=Part/Whole Percentage Change Calculator Percent increase or decrease from an old value to a new one. =(New-Old)/Old Percent Difference Calculator Difference between two values as a share of their average. ABS() + AVERAGE() Tip Calculator Tip, total and each person's share when splitting the bill. ROUND() GPA Calculator Term and cumulative GPA on a 4.0 scale from grades and credits. SUMPRODUCT() Hourly to Salary Calculator Turn an hourly wage into yearly, monthly and weekly pay, or back. =Rate*Hours*52 Age Calculator Exact age in years, months and days, and days to the next birthday. DATEDIF() Date Calculator Add or subtract days, weeks, months and years, or business days. EDATE() + WORKDAY() Days Between Dates Calculator Days, weeks, months and weekdays between two dates. NETWORKDAYS() Hours Calculator Time between two clock times, minus breaks, in hours and minutes. MOD() Time Card Calculator Weekly hours, overtime and pay from daily clock-in and out times. MOD() Random Group Generator Split a list of names into random, evenly sized groups. SORTBY() Square Footage Calculator Total area of one or more rooms, with waste and cost estimates. SUMPRODUCT() Military Time Converter Convert between 12-hour AM/PM time and 24-hour military time. TEXT() Ratio Calculator Solve a missing value in a ratio, or simplify one to lowest terms. GCD()