Formulas & functions
How a function works, with worked examples you can paste.
- Gross Margin Excel Calculation: Formula and ExamplesWith revenue in B2 and cost of goods sold (COGS) in C2, calculate gross margin in Excel with =(B2-C2)/B2, then format the…
- NPV Calculator in Excel: Formula, Example, and TipsTo calculate net present value (NPV) in Excel, enter the discount rate and future cash flows, then use =NPV(rate, future_cash_flows)+initial_cash_flow. Excel’s NPV…
- Weighted Average Calculator in Excel: Formula & ExamplesTo calculate a weighted average in Excel, multiply each value by its corresponding weight, add those products, and divide by the sum…
- Weighted Average in Excel: Formula and ExamplesExcel has no dedicated WEIGHTEDAVERAGE function; use SUMPRODUCT divided by SUM. With values in B2:B4 and their corresponding weights in C2:C4, enter…
- Variance Formula in Excel: Calculate Percentage VarianceTo calculate percentage variance in Excel, subtract the reference value from the actual value and divide by the reference value. With budget…
- Compound Interest Calculator in Excel: Formulas and TipsYes. In Microsoft Excel for Microsoft 365 on Windows, enter the starting balance, annual interest rate, number of years, and compounding periods…
- Amortization Schedule Excel Formula: Build It Step by StepTo calculate a fixed monthly loan payment in Excel, put the principal in B1, the annual interest rate in B2, and the…
- Break-Even Excel Formula: Calculate Units and SalesThe basic break-even formula in Excel is fixed costs divided by the contribution margin per unit: =B2/(B3-B4). If B2 contains fixed costs,…
- Calculate CAGR Growth in Excel: Formula and ExamplesTo calculate compound annual growth rate (CAGR) in Excel, divide the ending value by the beginning value, raise the result to the…
- How to Calculate Row Totals in Excel with SUM FormulasTo calculate a row total in Excel, add a SUM formula in the cell where you want the answer. For example, with…
- Calculate Profit Margin % in Excel: Formula and StepsTo calculate profit margin in Excel, divide profit by revenue. With revenue in B2 and total costs in C2, enter =(B2-C2)/B2 in…
- How to Calculate ROI Percentage in Excel With a FormulaTo calculate return on investment (ROI) in Excel, subtract the investment cost from its final value, divide the result by the cost,…
- Python pandas Excel Functions: Read and Write FilesPython pandas handles Excel files mainly with read_excel() to load workbook data into a DataFrame and DataFrame.to_excel() to save data back to…
- Excel Attendance Percentage: Formula and ExamplesTo calculate attendance percentage in Excel, divide the number of sessions marked present by the number of recorded sessions, then format the…
- Excel Attendance Sheet With Overtime: Setup and FormulasYes. An Excel attendance sheet can calculate shift hours and overtime from employees’ start times, end times, and unpaid breaks. With start…
- Excel Attendance Sheet With Time: Setup and FormulasTo make an Excel attendance sheet with time, create columns for the date, employee, scheduled start, clock-in, clock-out, break minutes, and hours…
- Excel Timesheet Formulas for Overtime, Breaks, and PayFor a basic Excel timesheet, put a shift’s start time in B2, end time in C2, and unpaid break length in hours…
- Excel Timesheet Formula Minus Lunch: Simple ExamplesTo subtract an unpaid lunch entered as minutes, put the shift start in B2, the end in C2, and lunch minutes in…
- Excel Timesheet Formula With Breaks and Overnight ShiftsWith a shift start in B2, shift end in C2, break start in D2, and break end in E2, enter this in…
- Excel Timesheet Calculator Formula: Examples and TipsFor an Excel timesheet with start time in B2, end time in C2, and an unpaid break duration in D2, enter =MOD(C2-B2,1)-D2…
- Excel Biweekly Timesheets: Setup and Formula GuideYes. Excel can track biweekly timesheets by recording each shift in a 14-day date range, calculating hours, and adding each employee’s hours…
- Excel Time Sheets for Employees: Setup, Formulas and TipsYes. Excel can track employee start times, finish times, unpaid breaks, and hours worked in a reusable time sheet. Set up one…
- Excel Time Sheet Sample: Layout, Formulas, and TipsAn Excel time sheet sample is a worksheet for recording each workday’s start time, unpaid break, end time, and hours worked. The…
- Excel Budgeting and Forecasting Functions: A Practical GuideExcel budgeting and forecasting functions help you total planned and actual spending, compare results with a budget, and estimate future values from…
- Excel Accounting Formulas Cheat Sheet for Daily BooksAn Excel accounting formulas cheat sheet starts with =SUM(range) for totals, a simple addition formula for running balances, and criteria-based formulas such…
- Excel Accounting Shortcuts: Formulas, Keys, and TipsExcel accounting shortcuts are a mix of keyboard commands and formulas: use Alt+= to insert an AutoSum, Ctrl+T to turn transaction data…
- Excel Data Model: How to Sort Two Columns TogetherYes—but the right method depends on what you mean by “sort two columns.” In Excel for Microsoft 365 on Windows, use a…
- Excel Data Analysis Books: How to Choose the Right OneGood Excel data-analysis books include Microsoft Excel Data Analysis and Business Modeling by Wayne L. Winston for business modeling, Data Analysis with…
- Excel Data Analysis Cheat Sheet: Formulas and ToolsAn Excel data analysis cheat sheet is a quick guide to preparing data, summarizing it with formulas or PivotTables, and presenting useful…
- DAX Formula in Excel to Remove Duplicates: What WorksThere is no DAX formula in an Excel worksheet that deletes duplicate rows. For a live list of distinct values in Microsoft…