| Date | yes |
| Add (Subtract) Days to a Date | |
| Concatenate Dates | |
| Convert Date to Number | |
| Convert Date to Text | |
| Month Name to Number | |
| Create Date Range from Dates | |
| Day Number of Year | |
| Month Name from Date | |
| First Day of Month | |
| Add (Subtract) Weeks to a Date | |
| If Functions with Dates | |
| Max Date | |
| Number of Days Between Dates | |
| Number of Days in a Month | |
| Number of Weeks Between Dates | |
| Number of Years Between Dates | |
| Split Date & Time into Separate Cells | |
| Countdown Remaining Days | |
| Insert Dates | |
| Random Date Generator | |
| Using Dynamic Ranges - Year to Date Values | |
| Add (Subtract) Years to a Date | |
| Date Formula Examples | |
| |
| Get Day Name from Date | |
| Count Days Left in Month / Year | |
| Count Workdays Left in Month / Year | |
| Get Last Day of Month | |
| Last Business Day of Month / Year | |
| Number of Work / Business Days in Month | |
| Weekday Abbreviations | |
| Auto Populate Dates | |
| Number of Months Between Dates | |
| Quarter from a Date | |
| Years of Service | |
| Change Date Format | |
| Compare Dates | |
| Time | yes |
| Add (Subtract) Hours to Time | |
| Add (Subtract) Minutes to Time | |
| Add (Subtract) Seconds to Time | |
| Add Up time (Total Time) | |
| Time Differences | |
| Change Time Format | |
| Convert Minutes to Hours | |
| Convert Time to Decimal | |
| Convert Time to Hours | |
| Convert Time to Minutes | |
| Convert Time to Seconds | |
| Military Time | |
| Round Time to Nearest 15 Minutes | |
| Overtime Calculator | |
| Number of Hours Between Times | |
| Convert Seconds to Minutes, Hours, or Time | |
| Count Hours Worked | |
| Time Differences | |
| Time Format - Show Minutes Seconds | |
| Text | yes |
| Add Commas to Cells | |
| Get First Word from Text | |
| Capitalize First Letter | |
| Clean & Format Phone #s | |
| |
| Add Spaces to Cell | |
| Assign Number Value to Text | |
| Combine Cells with Comma | |
| Combine First and Last Names | |
| Convert Text String to Date | |
| Convert Text to Number | |
| |
| |
| Remove Unwated Characters | |
| |
| How to Split Text String by Space, Comma, & More | |
| Remove Special Characters | |
| Remove First Characters from Left | |
| Substitute Multiple Values | |
| Switch First & Last Names w/ Commas | |
| Remove Specific Text from a Cell | |
| |
| Add Leading Zeros to a Number | |
| Remove Line Breaks from Text | |
| Remove all Numbers from Text | |
| Reverse Text | |
| Remove Non-Numeric Characters | |
| Remove Last Character(s) From Right | |
| Separate First and Last Names | |
| Separate Text & Numbers | |
| Round | yes |
| Round Formulas | |
| Round Price to Nearest Dollar or Cent | |
| Round to Nearest 10, 100, or 1000 | |
| Round to Nearest 5 or .5 | |
| Round Percentages | |
| Round to Significant Figures | |
| Count | yes |
| Count Blank and Non-blank Cells | |
| Count Cells Between Two Numbers | |
| Count Cells not Equal to | |
| Count if Cells are in Range | |
| Count Times Word Appears in Cell | |
| Count Words in Cell | |
| |
| Count Specific Characters in Column | |
| Count Total Number of Characters in Column | |
| Count Cells that Equal one of two Results | |
| Count Cells that do not Contain | |
| Count Cells that Contain Specific Text | |
| Count Unique Values in Range | |
| Countif - Multiple Criteria | |
| Count Total Number of Cells in Range | |
| Count Cells with Any Text | |
| Count Total Cells in a Table | |
| Lookup | yes |
| Two Dimensional VLOOKUP | |
| VLOOKUP Simple Example | |
| Vlookup - Multiple Matches | |
| Case Sensitive Lookup | |
| Case Sensitive VLOOKUP | |
| Sum if - VLOOKUP | |
| Case Sensitive Lookup | |
| Case Sensitive VLOOKUP | |
| Find Duplicates w/ VLOOKUP or MATCH | |
| |
| INDEX MATCH MATCH | |
| Lookup - Return Cell Address (Not Value) | |
| Lookup Last Value in Column or Row | |
| Reverse VLOOKUP (Right to Left) | |
| Risk Score Bucket with VLOOKUP | |
| Sum with a VLOOKUP Function | |
| VLOOKUP & INDIRECT | |
| VLOOKUP Concatenate | |
| VLOOKUP Contains (Partial Match) | |
| 17 Reasons Why Your XLOOKUP is Not Working | |
| Double (Nested) XLOOKUP - Dynamic Columns | |
| IFERROR (& IFNA) XLOOKUP | |
| Lookup Min / Max Value | |
| Nested VLOOKUP | |
| Top 11 Alternatives to VLOOKUP (Updated 2022!) | |
| VLOOKUP – Dynamic Column Reference | |
| VLOOKUP – Fix #N/A Error | |
| VLOOKUP – Multiple Sheets at Once | |
| VLOOKUP & HLOOKUP Combined | |
| VLOOKUP & MATCH Combined | |
| VLOOKUP Between Worksheets or Spreadsheets | |
| VLOOKUP Duplicate Values | |
| VLOOKUP Letter Grades | |
| VLOOKUP Return Multiple Columns | |
| VLOOKUP Returns 0? Return Blank Instead | |
| VLOOKUP w/o #N/A Error | |
| XLOOKUP Multiple Sheets at Once | |
| XLOOKUP Between Worksheets or Spreadsheets | |
| XLOOKUP by Date | |
| XLOOKUP Duplicate Values | |
| XLOOKUP Multiple Criteria | |
| XLOOKUP Return Multiple Columns | |
| XLOOKUP Returns 0? Return Blank Instead | |
| XLOOKUP Text | |
| XLOOKUP with IF | |
| XLOOKUP With If Statement | |
| Misc. | yes |
| Sort Multiple Columns | |
| Use Cell Value in Formula | |
| Percentage Change Between Numbers | |
| Percentage Breakdown | |
| Rank Values | |
| Add Spaces to Cell | |
| CAGR Formula | |
| Average Time | |
| Decimal Part of Number | |
| Integer Part of a Number | |
| Compare Items in a List | |
| Dealing with NA() Errors | |
| Get Worksheet Name | |
| Wildcard Characters | |
| Hyperlink to Current Folder | |
| Compound Interest Formula | |
| Percentage Increase | |
| Create Random Groups | |
| Sort with the Small and Large Functions | |
| Non-volatile Function Alternatives | |
| Decrease a Number by a Percentage | |
| Calculate Percent Variance | |
| Profit Margin Calculator | |
| Convert Column Number to Letter | |
| Get Full Address of Named Range | |
| Insert File Name | |
| Insert Path | |
| Latitute / Longitude Functions | |
| Replace Negative Values | |
| Reverse List Range | |
| |
| Convert State Name to Abbreviation | |
| Create Dynamic Hyperlinks | |
| Custom Sort List with Formula | |
| Data Validation - Custom Formulas | |
| Dynamic Sheet Reference (INDIRECT) | |
| Reference Cell in Another Sheet or Workbook | |
| Get Cell Value by Address | |
| Get Worksheet Name | |
| Increment Cell Reference | |
| List Sheet Names | |
| List Skipped Numbers in Sequence | |
| Return Address of Max Value in Range | |
| Search by Keywords | |
| Select Every Other (or Every nth) Row | |
| Basics | yes |
| Cell Reference Basics - A1, R1C1, 3d, etc. | |
| Add Up (Sum) Entire Column or Row | |
| Into to Dynamic Array Formulas | |
| Conversions | yes |
| Convert Time Zones | |
| Convert Celsius to Fahrenheit | |
| Convert Pounds to Kilograms | |
| Convert Time to Unix Time | |
| Convert Feet to Meters | |
| Convert Centimeters to Inches | |
| Convert Kilometers to Miles | |
| Convert Inches to Feet | |
| Convert Date to Julian Format | |
| Convert Column Letter to Number | |
| Tests | yes |
| Test if a Range Contains any Text | |
| Test if any Cell in Range is Number | |
| Test if a Cell Contains a Specific Value | |
| |
| |
| Test if Cell Contains Any Number | |
| Test if Cell Contains Specific Number | |
| Test if Cell is Number or Text | |
| If | yes |
| Percentile If | |
| Subtotal If | |
| Sumproduct If | |
| Large If and Small If | |
| Median If | |
| Concatentate If | |
| Max If | |
| Rank If | |
| TEXTJOIN If | |
| Sum | yes |
| Sum if - Begins With / Ends With | |
| Sum if - Month or Year to Date | |
| Sum if - By Year | |
| Sum if - Blank / Non-Blank | |
| Sum if - Horizontal Sum | |
| Count / Sum If - Cell Color | |
| INDIRECT Sum | |
| Sum If - Across Multiple Sheets | |
| Sum If - By Month | |
| Sum If - Cells Not Equal To | |
| Sum If - Not Blank | |
| Sum if - Between Values | |
| Sum If - Week Number | |
| Sum Text | |
| Sum if - By Category or Group | |
| Sum if - Cell Contains Specific Text (Wildcards) | |
| Sum if - Date Rnage | |
| Sum if - Dates Equal | |
| Sum if - Day of Week | |
| Sum if - Greater Than | |
| Sum if - Less Than | |
| Average | yes |
| Average Non-Zero Values | |
| Average If - Not Blank | |
| Average - Ignore 0 | |
| Average - Ignore Errors | |
| Math | yes |
| Multiplication Table | |
| Cube Roots | |
| nth Roots | |
| Square Numbers | |
| Square Roots | |
| Calculations | yes |
| Calculate a Ratio | |
| Calculate Age | |
| Calculate Loan Payments | |
| GPA Formula | |
| Calculate VAT Tax | |
| How to Grade Formulas | |
| Find | yes |
| Find a Number in a Column / Workbook | |
| Find Most Frequent Numbers | |
| Find Smallest n Values | |
| Find nth Occurance of Character in Text | |
| |
| Find Earliest or Latest Date Based on Criteria | |
| Find First Cell with Any Value | |
| Find Last Row | |
| Find Last Row with Data | |
| Find Missing Values | |
| Find Largest n Values | |
| Most Frequent Number | |
| Conditional Formatting | yes |
| Conditional Format - Dates & Times | |
| Conditional Format - Highlight Blank Cells | |
| New Functions | |
| UNIQUE | Returns a list of unique values in a list or range |
| XLOOKUP | Replaces VLOOKUP, HLOOKUP, and INDEX / MATCH |
| Logical | yes |
| AND | Checks whether all conditions are met. TRUE/FALSE |
| IF | If condition is met, do something, if not, do something else. |
| IFERROR | If result is an error then do something else. |
| NOT | Changes TRUE to FALSE and FALSE to TRUE. |
| OR | Checks whether any conditions are met. TRUE/FALSE |
| XOR | Checks whether one and only one condition is met. TRUE/FALSE |
| Lookup & Reference | yes |
| FALSE | The logical value: FALSE. |
| TRUE | The logical value: TRUE. |
| ADDRESS | Returns a cell address as text. |
| AREAS | Returns the number of areas in a reference. |
| CHOOSE | Chooses a value from a list based on it's position number. |
| COLUMN | Returns the column number of a cell reference. |
| COLUMNS | Returns the number of columns in an array. |
| HLOOKUP | Lookup a value in the first row and return a value. |
| HYPERLINK | Creates a clickable link. |
| INDEX | Returns a value based on it's column and row numbers. |
| INDIRECT | Creates a cell reference from text. |
| LOOKUP | Looks up values either horizontally or vertically. |
| MATCH | Searches for a value in a list and returns its position. |
| OFFSET | Creates a reference offset from a starting point. |
| ROW | Returns the row number of a cell reference. |
| ROWS | Returns the number of rows in an array. |
| TRANSPOSE | Flips the oriention of a range of cells. |
| VLOOKUP | Lookup a value in the first column and return a value. |
| Date & Time | yes |
| DATE | Returns a date from year, month, and day. |
| DATEDIF | Number of days, months or years between two dates. |
| DATEVALUE | Converts a date stored as text into a valid date |
| DAY | Returns the day as a number (1-31). |
| DAYS | Returns the number of days between two dates. |
| DAYS360 | Returns days between 2 dates in a 360 day year. |
| EDATE | Returns a date, n months away from a start date. |
| EOMONTH | Returns the last day of the month, n months away date. |
| HOUR | Returns the hour as a number (0-23). |
| MINUTE | Returns the minute as a number (0-59). |
| MONTH | Returns the month as a number (1-12). |
| NETWORKDAYS | Number of working days between 2 dates. |
| NETWORKDAYS.INTL | Working days between 2 dates, custom weekends. |
| NOW | Returns the current date and time. |
| SECOND | Returns the second as a number (0-59) |
| TIME | Returns the time from a hour, minute, and second. |
| TIMEVALUE | Converts a time stored as text into a valid time. |
| TODAY | Returns the current date. |
| WEEKDAY | Returns the day of the week as a number (1-7). |
| WEEKNUM | Returns the week number in a year (1-52). |
| WORKDAY | The date n working days from a date. |
| WORKDAY.INTL | The date n working days from a date, custom weekends. |
| YEAR | Returns the year. |
| YEARFRAC | Returns the fraction of a year between 2 dates. |
| Engineering | yes |
| CONVERT | Convert number from one unit to another. |
| Financial | yes |
| FV | Calculates the future value. |
| PV | Calculates the present value. |
| NPER | Calculates the total number of payment periods. |
| PMT | Calculates the payment amount. |
| RATE | Calculates the interest Rate. |
| NPV | Calculates the net present value. |
| IRR | The internal rate of return for a set of periodic CFs. |
| XIRR | The internal rate of return for a set of non-periodic CFs. |
| PRICE | Calculates the price of a bond. |
| YIELD | Calculates the bond yield. |
| INTRATE | The interest rate of a fully invested security. |
| Information | yes |
| CELL | Returns information about a cell. |
| ERROR.TYPE | Returns a value representing the cell error. |
| ISBLANK | Test if cell is blank. TRUE/FALSE |
| ISERR | Test if cell value is an error, ignores #N/A. TRUE/FALSE |
| ISERROR | Test if cell value is an error. TRUE/FALSE |
| ISEVEN | Test if cell value is even. TRUE/FALSE |
| ISFORMULA | Test if cell is a formula. TRUE/FALSE |
| ISLOGICAL | Test if cell is logical (TRUE or FALSE). TRUE/FALSE |
| ISNA | Test if cell value is #N/A. TRUE/FALSE |
| ISNONTEXT | Test if cell is not text (blank cells are not text). TRUE/FALSE |
| ISNUMBER | Test if cell is a number. TRUE/FALSE |
| ISODD | Test if cell value is odd. TRUE/FALSE |
| ISREF | Test if cell value is a reference. TRUE/FALSE |
| ISTEXT | Test if cell is text. TRUE/FALSE |
| N | Converts a value to a number. |
| NA | Returns the error: #N/A. |
| TYPE | Returns the type of value in a cell. |
| Math | yes |
| ABS | Calculates the absolute value of a number. |
| AGGREGATE | Define and perform calculations for a database or a list. |
| CEILING | Rounds a number up, to the nearest specified multiple. |
| COS | Returns the cosine of an angle. |
| DEGREES | Converts radians to degrees. |
| DSUM | Sums database records that meet certain criteria. |
| EVEN | Rounds to the nearest even integer. |
| EXP | Calculates the exponential value for a given number. |
| FACT | Returns the factorial. |
| FLOOR | Rounds a number down, to the nearest specified multiple. |
| GCD | Returns the greatest common divisor. |
| INT | Rounds a number down to the nearest integer. |
| LCM | Returns the least common multiple. |
| LN | Returns the natural logarithm of a number. |
| LOG | Returns the logarithm of a number to a specified base. |
| LOG10 | Returns the base-10 logarithm of a number. |
| MOD | Returns the remainder after dividing. |
| MROUND | Rounds a number to a specified multiple. |
| ODD | Rounds to the nearest odd integer. |
| PI | The value of PI. |
| POWER | Calculates a number raised to a power. |
| PRODUCT | Multiplies an array of numbers. |
| QUOTIENT | Returns the integer result of division. |
| RADIANS | Converts an angle into radians. |
| RAND | Calculates a random number between 0 and 1. |
| RANDBETWEEN | Calculates a random number between two numbers. |
| ROUND | Rounds a number to a specified number of digits. |
| ROUNDDOWN | Rounds a number down (towards zero). |
| ROUNDUP | Rounds a number up (away from zero). |
| SIGN | Returns the sign of a number. |
| SIN | Returns the sine of an angle. |
| SQRT | Calculates the square root of a number. |
| SUBTOTAL | Returns a summary statistic for a series of data. |
| SUM | Adds numbers together. |
| SUMIF | Sums numbers that meet a criteria. |
| SUMIFS | Sums numbers that meet multiple criteria. |
| SUMPRODUCT | Multiplies arrays of numbers and sums the resultant array. |
| TAN | Returns the tangent of an angle. |
| TRUNC | Truncates a number to a specific number of digits. |
| Stats | yes |
| AVERAGE | Averages numbers. |
| AVERAGEA | Averages numbers. Includes text & FALSE =0, TRUE =1. |
| AVERAGEIF | Averages numbers that meet a criteria. |
| AVERAGEIFS | Averages numbers that meet multiple criteria. |
| CORREL | Calculates the correlation of two series. |
| COUNT | Counts cells that contain a number. |
| COUNTA | Count cells that are non-blank. |
| COUNTBLANK | Counts cells that are blank. |
| COUNTIF | Counts cells that meet a criteria. |
| COUNTIFS | Counts cells that meet multiple criteria. |
| FORECAST | Predict future y-values from linear trend line. |
| FREQUENCY | Counts values that fall within specified ranges. |
| GROWTH | Calculates Y values based on exponential growth. |
| INTERCEPT | Calculates the Y intercept for a best-fit line. |
| LARGE | Returns the kth largest value. |
| LINEST | Returns statistics about a trendline. |
| MAX | Returns the largest number. |
| MEDIAN | Returns the median number. |
| MIN | Returns the smallest number. |
| MODE | Returns the most common number. |
| PERCENTILE | Returns the kth percentile. |
| PERCENTILE.INC | Returns the kth percentile. Where k is inclusive. |
| PERCENTILE.EXC | Returns the kth percentile. Where k is exclusive. |
| QUARTILE | Returns the specified quartile value. |
| QUARTILE.INC | Returns the specified quartile value. Inclusive. |
| QUARTILE.EXC | Returns the specified quartile value. Exclusive. |
| RANK | Rank of a number within a series. |
| RANK.AVG | Rank of a number within a series. Averages. |
| RANK.EQ | Rank of a number within a series. Top Rank. |
| SLOPE | Calculates the slope from linear regression. |
| SMALL | Returns the kth smallest value. |
| STDEV | Calculates the standard deviation. |
| STDEV.P | Calculates the SD of an entire population. |
| STDEV.S | Calculates the SD of a sample. |
| STDEVP | Calculates the SD of an entire population |
| TREND | Calculates Y values based on a trendline. |
| Text | yes |
| CHAR | Returns a character specified by a code. |
| CLEAN | Removes all non-printable characters. |
| CODE | Returns the numeric code for a character. |
| CONCATENATE | Combines text together. |
| DOLLAR | Converts a number to text in currency format. |
| EXACT | Test if cells are exactly equal. Case-sensitive. TRUE/FALSE |
| FIND | Locates position of text within a cell.Case-sensitive. |
| LEFT | Truncates text a number of characters from the left. |
| LEN | Counts number of characters in text. |
| LOWER | Converts text to lower case. |
| MID | Extracts text from the middle of a cell. |
| PROPER | Converts text to proper case. |
| REPLACE | Replaces text based on it's location. |
| REPT | Repeats text a number of times. |
| RIGHT | Truncates text a number of characters from the right. |
| SEARCH | Locates position of text within a cell.Not Case-sensitive. |
| SUBSTITUTE | Finds and replaces text. Case-sensitive. |
| TEXT | Converts a value into text with a specific number format. |
| TRIM | Removes all extra spaces from text. |
| UPPER | Converts text to upper case. |
| VALUE | Converts a number stored as text into a number. |
