Formulas & functions
How a function works, with worked examples you can paste.
- Attendance Counting Formula in Excel: Count Days PresentIf each student’s daily attendance marks are in B2:AF2 and P means present, use =COUNTIF(B2:AF2,"P") to count days present; if 18 cells…
- Attendance Excel Sheet With Formula: Setup and ExamplesYes. An attendance Excel sheet can use COUNTIF to count attendance codes and calculate a rate. If one learner’s 20 scheduled sessions…
- Attendance Calculation in Excel: Formulas and ExamplesTo calculate attendance in Excel, divide the number of sessions marked present by the number of sessions with a recorded present or…
- Array Formula in Excel: How It WorksAn array formula in Excel works with multiple values at once and can return either one result or a range of results.…
- Attendance Calculation Formula in Excel With ExamplesTo calculate attendance in Excel, divide the number of sessions marked present by the number of sessions counted under your attendance policy.…
- Approximate Match Lookup in Excel: Formulas and TipsFor a numeric approximate lookup in Excel, use an ascending threshold table and a formula that returns the largest threshold not greater…
- Array Formula in Excel: Examples, Uses, and Key TipsAn Excel array formula works with multiple values at once, either returning one result or spilling a set of results into neighboring…
- Amortization Table Excel Formulas: Build a Loan ScheduleAn Excel amortization table uses PMT to calculate a regular loan payment, then formulas to split each payment into interest and principal…
- Advanced SUMPRODUCT in Excel: Practical FormulasAdvanced SUMPRODUCT formulas let Excel multiply corresponding values, apply one or more conditions, and add only the results that qualify—all in a…
- Add Workdays to a Date in Excel: Formula and ExamplesTo add workdays to a date in Excel, use =WORKDAY(A2,B2), where A2 contains the starting date and B2 contains the number of…
- Add a Sequence in Excel with the SEQUENCE FunctionTo add a numbered sequence in Excel, enter =SEQUENCE(10) in a blank cell to spill the numbers 1 through 10 into the…
- Accumulated Depreciation Formula in ExcelFor straight-line depreciation, accumulated depreciation is the depreciation recorded to date: annual depreciation multiplied by the number of years used, capped at…
- Absolute References in Excel Table FormulasYes—you can use absolute cell references in Excel table formulas by adding dollar signs to the cell address, such as $H$2. For…
- Excel Structured References: Tables, Formulas, and ExamplesA structured reference is an Excel formula reference that identifies data in a table by its table and column names instead of…
- Structured Reference Excel Formula: Syntax and ExamplesA structured reference formula uses an Excel table’s name and column headings instead of ordinary cell addresses. For example, with a table…
- Protect an Excel Sheet with a Formula? What Actually WorksNo Excel worksheet formula can turn sheet protection on or lock cells; protection is a command, not a formula. To protect formulas,…
- Excel Named Range Formula: How to Create and Use OneIn Excel, a named range is a meaningful name assigned to a cell or range, and its formula is entered in the…
- What-If Analysis in Excel: How It Works and When to Use ItWhat-If Analysis in Excel is a set of tools for seeing how changing input values affects a formula’s result. In Microsoft Excel…
- Excel Z Score Function: Formula and ExamplesExcel’s z-score function is STANDARDIZE, which calculates how many standard deviations a value is from a mean. If the value is in…
- Excel What-If Analysis: Helpful Tips and ScenariosExcel what-if analysis helps you see how changing input values affects a formula’s result. For a quick target, use Data > What-If…
- Excel Yield Analysis: Formulas for Bonds and ProductionExcel yield analysis depends on what you mean by yield: for a bond’s yield to maturity, use Excel’s YIELD function; for a…
- Excel Two-Variable Data Tables: How What-If Analysis WorksIn Excel, a two-variable data table shows how one formula’s result changes across combinations of two input values. Put the formula in…
- Excel What-If Analysis with Goal Seek: A Practical GuideIn Excel for Microsoft 365 on Windows, use Goal Seek to find the input value that makes a formula return a result…
- Excel Vector Analysis: Operations, Formulas, and UsesExcel has no dedicated “vector analysis” tool or vector data type, but it can perform common vector calculations by treating matching cells…
- Excel Quadratic Formula: Solve Equations in a SheetYes. Excel can calculate the roots of a quadratic equation with the quadratic formula: enter the coefficients a, b, and c in…
- Excel Quadratic Equations: How to Solve Them with FormulasYes. Excel can solve a quadratic equation by calculating its roots with the quadratic formula, or by using Goal Seek to find…
- Excel Solve Quadratic Equations: Formulas and ExamplesYes. In Excel for Microsoft 365, enter the coefficients a, b, and c in cells B2, B3, and B4, then use the…
- Excel Probability Analysis: Methods, Formulas, and ExamplesExcel probability analysis means estimating or calculating the chance of an event from observed data, a probability model, or repeated simulations. For…
- Excel Quantity Analysis: Formulas, Checks, and ExamplesExcel quantity analysis means organizing quantity records and summarizing them to answer questions such as how many units were sold, received, used,…
- Excel What-If Analysis: Tools and ExamplesExcel What-If Analysis lets you change assumptions in a worksheet and see how those changes affect a result. In Microsoft 365 for…