Formulas & functions
How a function works, with worked examples you can paste.
- CHAR Excel Usage Examples: Formulas, Codes, and TipsIn Excel, CHAR converts a number from the computer’s character set into a character. For example, with no cell references needed, =CHAR(65)…
- CHAR Excel Examples: Formulas, Line Breaks, and MoreIn Excel for Microsoft 365, use CHAR(number) to return the character assigned to a numeric code, such as CHAR(65) for A or…
- ABS Function in Excel: Examples and Practical UsesExcel’s ABS function returns the absolute value of a number: its distance from zero, without a negative sign. To try it directly…
- ABS Excel Examples: Formulas and UsesIn Excel, use =ABS(number) to return a number’s distance from zero without its negative sign: for example, =ABS(-25) returns 25. ABS is…
- Excel Timesheet Formula: Total Hours, Breaks, and ShiftsFor a timesheet with a start time in B2, an end time in C2, and an unpaid break duration in D2, enter…
- Power Query XLOOKUP From Another Table: How It WorksPower Query does not run the Excel XLOOKUP function inside a query. To return columns from another table, use Merge Queries to…
- Power Query VLOOKUP: Match Data From Another TableYes. In Excel for Microsoft 365, Power Query can look up values in another table by merging the two queries: choose a…
- Power Query XLOOKUP: Matching Data in Excel ExplainedPower Query does not have an XLOOKUP function. To match rows from two tables in Power Query, use Merge Queries; use the…
- Power Query VLOOKUP: How to Match Tables in Excel InsteadPower Query does not have a VLOOKUP function; use Merge Queries to match rows from two tables and bring a column of…
- Power Query Custom Column IF Statement: ExamplesTo write an IF statement in a Power Query custom column, use M’s if … then … else expression, such as if…
- Excel Time Conversion Formula: Hours, Minutes, and MoreIf A2 contains an Excel time, multiply it by 24 to get decimal hours: =A2*24. For decimal minutes, use =A2*1440, and for…
- Excel Time Card Calculator: Formulas, Setup, and TipsYes. In Excel for Microsoft 365 on Windows, a basic time card calculator can subtract clock-in from clock-out, deduct an unpaid break,…
- Excel Word Count Formula: Count Words in Cells and TextTo count words in a cell in Excel, use =IF(TRIM(A2)="",0,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ",""))+1), replacing A2 with the cell you want to check. It returns…
- Excel Formula for Time Difference: Examples and FixesTo find the time between two values in Excel, subtract the start time from the end time: with the start time in…
- Excel Formula for Weeks Between Two Dates: Full WeeksTo calculate weeks between two dates in Excel, subtract the start date from the end date and divide by 7. If the…
- Excel Formula for Serial Numbers: Methods That WorkThe simplest Excel formula for a serial number is =ROW()-1, entered in A2 when row 1 contains a heading. It returns 1…
- Excel Formula for Time Between DatesTo find the time between two dates in Excel, subtract the earlier date or date-time from the later one: if the start…
- Excel Formula for Time Clock Hours In and Out by ShiftFor clock-in time in A2 and clock-out time in B2, enter =MOD(B2-A2,1)*24 to return the shift length as decimal hours, including a…
- Excel Formula for Row Number: ROW and ROWS ExplainedTo return the worksheet row number of the cell containing a formula, use =ROW(). To return the row number of a specific…
- Excel Formula for Quarterly Dates: Examples and TipsTo calculate the first day of the calendar quarter containing a date in A2, use =DATE(YEAR(A2),3*INT((MONTH(A2)-1)/3)+1,1). For example, if A2 contains November…
- Excel Formula for Random Selection From a List: GuideTo return one random item from a contiguous list in Excel, use =INDEX(A2:A20,RANDBETWEEN(1,ROWS(A2:A20))). If your items are in A2:A20, the formula returns…
- Excel Formula for Number of Years From a Date, ExplainedTo calculate completed years from a date in Excel, use =DATEDIF(A2,TODAY(),"Y"), where A2 contains the starting date. For years between two dates…
- Excel Formula for Hours Worked: Calculate Time and PayFor a shift that starts in A2 and ends in B2, enter =MOD(B2-A2,1)*24 to return hours as a decimal, including for a…
- Excel Formula for Holiday Dates: Fixed and Moving DaysFor a holiday that falls on the same month and day each year, use =DATE($B$1,1,1), assuming the year is in B1; for…
- Excel Formula for High and Low Values: MIN and MAXIn Excel, use =MIN(B2:B10) to find the lowest number in a range and =MAX(B2:B10) to find the highest. Replace B2:B10 with your…
- Excel Formula for Hours Between Two TimesTo calculate hours between two times in Excel, subtract the start time from the end time and multiply by 24. If the…
- Excel Formula for Difference Between Two Numbers ExplainedTo find the difference between two numbers in Excel, subtract one cell from the other: if the first number is in A2…
- Excel Formula for First Day of Month: ExamplesIf the date you want to use is in cell A2, enter =DATE(YEAR(A2),MONTH(A2),1) to return the first day of its month. For…
- Excel Formula for Calculating Days Between DatesTo calculate the number of elapsed days between two dates in Excel, subtract the earlier date from the later one. If the…
- Excel Formula for Current Date: TODAY ExplainedIn Microsoft Excel for Microsoft 365 on Windows, enter =TODAY() in a cell to display the current date. The date updates when…