Formulas & functions
How a function works, with worked examples you can paste.
- Calendar Date Formula in Excel: ExamplesThe most useful Excel calendar date formula is =DATE(year,month,day), which combines a year, month, and day into a valid date. For example,…
- Calculating ROI in Excel: Formulas, Examples, and TipsTo calculate return on investment (ROI) in Excel, subtract the investment cost from the value it generated, then divide by the cost.…
- Average in Excel: Formulas, Examples, and Common FixesTo calculate an average in Excel, use =AVERAGE(B2:B10) if the numbers are in cells B2 through B10. The formula adds the numeric…
- PV in Excel: Calculate Present Value With the PV FunctionTo calculate present value in Excel, use the PV function: =PV(rate,nper,pmt,[fv],[type]). For example, with a 5% annual rate and three end-of-year payments…
- Calculating NPV and IRR in Excel: Formulas and StepsTo calculate NPV in Excel, discount the future cash flows with NPV and add the initial cash flow separately; to calculate IRR,…
- Calculating NPV in Excel: Formula, Steps, and ExamplesTo calculate net present value in Excel, place the discount rate in B1, the initial investment in B2, and the later cash…
- Calculating PMT in Excel: Formula, Payments, and ExamplesTo calculate a fixed periodic loan payment in Excel, use the PMT function, making sure the interest rate and number of periods…
- Calculating Markup in Excel: Formulas and ExamplesTo calculate markup in Excel, subtract cost from selling price, then divide the difference by cost: with cost in B2 and selling…
- Calculating Loan Payments in Excel: PMT and ExamplesTo calculate a fixed monthly loan payment in Excel, enter the loan amount, annual interest rate, and term in years, then use…
- Calculating Moving Average in Excel: Formulas and TipsTo calculate a moving average in Excel, average a fixed-size group of consecutive values, then copy the formula down one row at…
- Calculating IRR in Excel: Formula, Examples, and TipsTo calculate IRR in Excel, put each periodic cash flow in one cell, including the initial investment as a negative number, then…
- Calculating CAGR in Excel: Formula, Examples, and TipsTo calculate CAGR in Excel, divide the ending value by the beginning value, raise the result to the power of one divided…
- Weighted Average Rate in Excel: Formula and ExamplesTo calculate a weighted average rate in Excel, multiply each rate by its corresponding weight, add those products, and divide by the…
- BMI Formula in Excel: Calculate It Step by StepTo calculate BMI in Excel, divide weight in kilograms by height in metres squared; for example, with weight in B2 and height…
- Calculate a Weighted Average in Excel: Formula and ExamplesTo calculate a weighted average in Excel, multiply each value by its weight, add those products, and divide by the sum of…
- Calculate Weekday from Date in Excel: Formulas and TipsTo calculate a weekday from a date in Excel, use =WEEKDAY(A2,2) if the date is in A2; Monday returns 1 and Sunday…
- Weighted Average Life in Excel: Formula and ExampleTo calculate weighted average life (WAL) in Excel, multiply each principal repayment by the time it is paid, add those products, and…
- SUMIF in Excel: Formula, Examples, and Common FixesTo total values that meet one condition in Excel, use SUMIF. With product names in A2:A6 and amounts in B2:B6, enter =SUMIF(A2:A6,"Apples",B2:B6)…
- Median in Excel Based on Criteria: Formulas and ExamplesIn Excel for Microsoft 365, calculate a median for matching rows with =MEDIAN(FILTER(B2:B20,(A2:A20="East")*ISNUMBER(B2:B20))). This example returns the median of numeric values in…
- Monthly Loan Payment Formula in ExcelTo calculate a fixed monthly loan payment in Excel, use PMT. With the loan principal in B1, the annual interest rate in…
- Calculate Days Left in Excel with Simple FormulasTo calculate days left in Excel, enter the deadline in A2 and use =A2-TODAY() in another cell. Excel returns the number of…
- Calculate Attendance in Excel: Formulas and ExamplesTo calculate attendance in Excel, enter a consistent status such as P for present or A for absent in each session column,…
- Calculate Annual ROI in Excel: Formula and ExamplesTo calculate annualized ROI in Excel, divide the ending value by the initial investment, raise the result to the power of one…
- CAGR Rate Excel Formula: Calculate Annualized GrowthIf B2 contains the beginning value, B3 the ending value, and B4 the number of years, calculate CAGR in Excel with =(B3/B2)^(1/B4)-1.…
- Calculate the Median in Excel: Formula and ExamplesTo calculate a median in Excel, use the MEDIAN function. If your numbers are in B2:B10, enter =MEDIAN(B2:B10); Excel returns the middle…
- Calculate ROI in Excel: Formula, Examples, and TipsTo calculate ROI in Excel, subtract the investment cost from the value it generated, then divide the result by the cost: =(B2-A2)/A2.…
- CAGR Calculation in Excel: Formula, Steps, and ExamplesTo calculate CAGR in Excel, divide the ending value by the starting value, raise the result to the power of one divided…
- CAGR Calculation Formula in Excel: Examples and TipsIn Excel, calculate CAGR by dividing the ending value by the beginning value, raising that ratio to the power of one divided…
- CAGR Calculator Excel Formula: Calculate Annual GrowthWith the starting value in A2, ending value in B2, and number of years in C2, calculate CAGR in Excel with =(B2/A2)^(1/C2)-1.…
- CAGR Calc Excel Formula: Calculate Annual Growth RateIf the beginning value is in B2, the ending value is in C2, and the number of years is in D2, calculate…