Formulas & functions
How a function works, with worked examples you can paste.
- 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…
- Budget Template With Formulas in Excel: Build Your OwnYes. A useful Excel budget template can use columns for category, type, planned amount, actual amount, and variance, with formulas to total…
- Budget Tracker Excel Template: Setup, Formulas, and TipsA budget tracker Excel template is a worksheet for listing planned spending beside actual spending and calculating what remains in each category.…
- Budget Excel Spreadsheet With Formulas: A Practical GuideYes. A useful budget Excel spreadsheet can be built with columns for category, planned amount, actual amount, and variance, then formulas to…
- BMI Formula in Excel: Calculate and Interpret ResultsTo calculate BMI in Excel, divide weight in kilograms by height in metres squared. If weight is in A2 in kilograms and…
- BMI Calculator in Excel: Formula and SetupTo make a BMI calculator in Excel, enter weight in kilograms in B2 and height in metres in C2, then put =B2/(C2^2)…
- BMI Formula for Excel: Metric and ImperialFor a metric BMI calculation in Excel, put weight in kilograms in B2 and height in meters in C2, then enter =B2/(C2^2).…
- BMI Calculation in Excel: Formula, Setup, and TipsTo calculate BMI in Excel, divide weight in kilograms by height in metres squared. If weight is in B2 and height in…
- BMI Calculator Excel Formula: Steps, Examples, and TipsTo calculate BMI in Excel, divide weight in kilograms by height in meters squared. If weight is in B2 and height in…
- BMI Calculator for Excel: Formula, Setup, and TipsTo make a BMI calculator in Excel, enter height in centimeters in A2 and weight in kilograms in B2, then use =IF(OR(A2="",B2="",A2<=0,B2<=0),"",B2/(A2/100)^2)…
- BMI Calculation in Excel: Formula and SetupTo calculate BMI in Excel using metric units, enter height in centimetres in A2 and weight in kilograms in B2, then use…
- Bing Chat Excel Formula Not Updating? Fixes That WorkIf a formula from Bing Chat is not updating in Excel, first check that it was entered as a real formula and…
- Best Way to Interpolate in Excel: Formulas for 5 CasesFor most workbooks, the best way to interpolate in Excel is piecewise linear interpolation: use the two data points immediately below and…
- Basic VLOOKUP in Excel: Formula, Examples, and FixesIn Excel, VLOOKUP searches for a value in the leftmost column of a range and returns a value from another column on…
- Basic Sum Formula in Excel: How to Add CellsIf A1:A4 contain 12, 8, 15, and 5, enter =SUM(A1:A4) in an empty cell to add them; the result is 40. The…
- Basic LAMBDA Function in Excel: How to Create OneA basic Excel LAMBDA turns a calculation into a function: with no worksheet cell layout required, enter =LAMBDA(x,x*2)(5) to double 5 and…
- Basic Invoice Template Excel: Setup and FormulasA basic invoice template in Excel can be made with invoice and customer details, a line-item table, and formulas for line totals,…
- Average Value in Excel: Formula, Examples, and TipsTo calculate an average value in Excel, use the AVERAGE function: with the numbers 12, 15, 18, 21, and 24 in cells…
- Average VLOOKUP in Excel: How to Average Matching RowsTo average values for every row that matches a lookup value, use AVERAGEIF rather than VLOOKUP. For example, if product names are…
- AVERAGEIF Formula in Excel: Syntax and Practical ExamplesIn Excel, use =AVERAGEIF(range, criteria, [average_range]) to average numbers that meet one condition. For example, with departments in A2:A6 and sales in…
- Average in Excel: Formula, Examples, and Common FixesTo calculate an average in Excel, use the AVERAGE function: with numbers in B2:B10, enter =AVERAGE(B2:B10). Excel returns the arithmetic mean of…
- Average Date in Excel: Formula, Examples, and FixesTo calculate an average date in Excel, use =AVERAGE(A2:A10) with dates in A2:A10, then format the result as a date. Excel averages…
- Average in Excel: Formula, Examples, and Common FixesTo calculate an average in Excel, use the AVERAGE function: if the numbers are in A1:A10, enter =AVERAGE(A1:A10) in an empty cell…
- Average Equation in Excel: Formulas, Uses, and ExamplesThe average equation in Excel is =AVERAGE(range). For example, with numbers in B2:B6, enter =AVERAGE(B2:B6) in another cell to calculate their arithmetic…
- Audit Formulas in Excel: Find Errors and Trace CellsTo audit formulas in Excel for Microsoft 365 on Windows, select a formula cell and choose Formulas > Formula Auditing > Trace…
- Attendance Sheet Format in Excel With Formulas and TotalsTo create an attendance sheet in Excel, put employee or student names in column A, dates across row 4, and enter P,…
- Attendance Time Calculation Formula in Excel: A GuideFor clock-in time in A2 and clock-out time in B2, calculate attendance duration with =MOD(B2-A2,1) and format the result as [h]:mm. The…
- Attendance Present Formula in Excel: Count It CorrectlyTo count attendance entries marked P in Excel, use COUNTIF: with the attendance marks in B2:B31, enter =COUNTIF(B2:B31,"P"). If the cells contain…
- Attendance Present Absent Formula in Excel: Easy SetupTo count attendance marks in Excel, use =COUNTIF(B2:U2,"P") for the number present and =COUNTIF(B2:U2,"A") for the number absent, assuming one student’s daily…
- Attendance Percentage Formula in ExcelTo calculate attendance percentage in Excel, divide the number of sessions attended by the total number of sessions held, then format the…