List of Excel

Formula Examples

Search our ever-growing formula list to find the formula example that meets your needs.

Excel Formula Examples  
Dateyes
Add (Subtract) Days to a Dateadd subtract days to date example download
Concatenate Datesconcatenate date example download
Convert Date to Numberdate to number example download
Convert Date to Textconvert date to text example download
Month Name to Numbermonth name to number example download
Create Date Range from Datescreate date range example download
Day Number of Yearday number of year example download
Month Name from Datemonth name from date example download
First Day of Monthfirst day month example download
Add (Subtract) Weeks to a Dateadd subtract weeks to date example download
If Functions with Datesif date example download
Max Datemax date example download
Number of Days Between Datesdays between dates example download
Number of Days in a Monthnumber days in month example download
Number of Weeks Between Datesweeks between dates example download
Number of Years Between Datesyears between dates example download
Split Date & Time into Separate Cellssplit date time example download
Countdown Remaining Dayscountdown remaining days example download
Insert Dates
Random Date Generatorrandom date generator example download
Using Dynamic Ranges - Year to Date Values
Add (Subtract) Years to a Dateadd subtract years to date example download
Date Formula Examples
Extract Day from Dateextract day from date example download
Get Day Name from Dateday name from date example download
Count Days Left in Month / Yeardays left month year example download
Count Workdays Left in Month / Yearworkdays left month year example download
Get Last Day of Monthlast day of month example download
Last Business Day of Month / Yearlast business day month year example download
Number of Work / Business Days in Monthworkdays in month example download
Weekday Abbreviationsweekday abbreviations example download
Auto Populate Datesauto populate dates example download
Number of Months Between Datesmonths between dates example download
Quarter from a Datequarter from date example download
Years of Serviceyears of service example download
Change Date Formatchange date format example download
Compare Datescompare two dates example download
Timeyes
Add (Subtract) Hours to Timeadd hours time example download
Add (Subtract) Minutes to Timeadd minutes to time example download
Add (Subtract) Seconds to Timeadd seconds to time example download
Add Up time (Total Time)total time example download
Time Differencestime difference example download
Change Time Formatchange time format example download
Convert Minutes to Hoursconvert minutes to hours example download
Convert Time to Decimalconvert time to decimal example download
Convert Time to Hoursconvert time to hours example download
Convert Time to Minutesconvert time to minutes example download
Convert Time to Secondsconvert time to seconds example download
Military Timemilitary time example download
Round Time to Nearest 15 Minutesround time example download
Overtime Calculatorovertime calculator example download
Number of Hours Between Timescalculate hours between times example download
Convert Seconds to Minutes, Hours, or Timeconvert seconds to minutes hours example download
Count Hours Workedcalculate hours worked example download
Time Differencestime difference hours minutes seconds example download
Time Format - Show Minutes Secondstime format show minutes seconds example download
Textyes
Add Commas to Cellsadd comma example download
Get First Word from Textget first word example download
Capitalize First Lettercapitalize first letter example download
Clean & Format Phone #sclean format phone numbers example download
Remove Extra Trailing / Leading Spacesremove extra trailing leading spaces example download
Add Spaces to Celladd spaces to cell example download
Assign Number Value to Textassign number value to text example download
Combine Cells with Commacombine cells comma example download
Combine First and Last Namescombine first last names example download
Convert Text String to Dateconvert text to date example download
Convert Text to Numberconvert text number example download
Extract Text From Cellextract text from cell example download
Get Last Wordextract last word example download
Remove Unwated Charactersremove unwanted characters example download
Extract Text Before or After Characterextract text before after character example download
How to Split Text String by Space, Comma, & Moresplit text space comma example download
Remove Special Charactersremove special characters example download
Remove First Characters from Leftremove first chars from left example download
Substitute Multiple Valuessubstitute multiple values example download
Switch First & Last Names w/ Commasswitch first last names commas example download
Remove Specific Text from a Cellremove specific text cell example download
Extract Text Between Characters (Ex. Parenthesis)extract text between characters parenthesis example download
Add Leading Zeros to a Numberadd leading zeros example download
Remove Line Breaks from Textremove line breaks example download
Remove all Numbers from Textremove numbers from text example download
Reverse Textreverse text example download
Roundyes
Round Formulasround functions example download
Round Price to Nearest Dollar or Centround price example download
Round to Nearest 10, 100, or 1000round to nearest 10 100 1000 example download
Round to Nearest 5 or .5round nearest 5 example download
Round Percentagesround percentages example download
Round to Significant Figuresround significant figures example download
Countyes
Count Blank and Non-blank Cellscount blank non blank cells example download
Count Cells Between Two Numberscount cells between two numbers example download
Count Cells not Equal tocount cells not equal to example download
Count if Cells are in Rangecount if cells in range example download
Count Times Word Appears in Cellcount times word appears in cell example download
Count Words in Cellcount words in cell example download
running count of occurrences in excel and google sheets example download
Count Specific Characters in Columncount specific characters column example download
Count Total Number of Characters in Columncount total characters column example download
Count Cells that Equal one of two Resultscount cells equal two results example download
Count Cells that do not Contain
Count Cells that Contain Specific Textcount cells that contain specific text example download
Count Unique Values in Rangecount unique values in range example download
Countif - Multiple Criteriacount if multiple criteria example download
Count Total Number of Cells in Rangetotal number of cells in range example download
Count Cells with Any Textcount cells with any text example download
Count Total Cells in a Tabletotal cells in table example download
Lookupyes
Two Dimensional VLOOKUP
VLOOKUP Simple Example
Vlookup - Multiple Matches
Case Sensitive Lookupexcel case sensitive lookup example download
Case Sensitive VLOOKUPcase sensitive vlookup excel google sheets example download
Sum if - VLOOKUPsum if vlookup example download
Case Sensitive Lookupcase sensitive lookup example download
Case Sensitive VLOOKUPvlookup case sensitive example download
Find Duplicates w/ VLOOKUP or MATCHfind duplicates vlookup match example download
INDEX MATCH MATCHindex match match 2d lookup example download
Lookup - Return Cell Address (Not Value)lookup cell address example download
Lookup Last Value in Column or Rowlookup last value column example download
Reverse VLOOKUP (Right to Left)reverse vlookup right to left example download
Risk Score Bucket with VLOOKUPrisk score bucket vlookup example download
Sum with a VLOOKUP Functionsum vlookup example download
VLOOKUP & INDIRECTvlookup indirect example download
VLOOKUP Concatenatevlookup concatenate example download
VLOOKUP Contains (Partial Match)vlookup contains partial match example download
Misc.yes
Sort Multiple Columnssort two columns example download
Use Cell Value in Formulause cell value in formula example download
Percentage Change Between Numberscalculate percentage change between numbers example download
Percentage Breakdownpercentage breakdown range example download
Rank Values
Add Spaces to Celladd spaces to cell rept example download
CAGR Formula
Average Timeaverage time example download
Decimal Part of Numberdecimal part of number example download
Integer Part of a Numberinteger part of number example download
Compare Items in a List
Dealing with NA() Errorsif isna vlookup example download
Get Worksheet Nameexcel formula get worksheet name example download
Wildcard Characterswildcard characters example download
Hyperlink to Current Folderhyperlink to current folder example download
Compound Interest Formula
Percentage Increasepercentage increase formula in excel example download
Create Random Groupsrandom groups example download
Sort with the Small and Large Functionssort with small large function example download
Non-volatile Function Alternativesnon volatile solutions example download
Decrease a Number by a Percentagedecrease by percentage example download
Calculate Percent Variancepercent variance example download
Profit Margin Calculatorprofit margin calculator example download
Convert Column Number to Letterconvert column number to letter example download
Get Full Address of Named Rangeget full address of named range example download
Insert File Nameinsert file name formula example download
Insert Pathinsert path formula example download
Latitute / Longitude Functions
Replace Negative Valuesnegative values with zero example download
Reverse List Rangereverse list range example download
Convert State Name to Abbreviationconvert state name abbreviation example download
Create Dynamic Hyperlinksdynamic hyperlinks example download
Custom Sort List with Formulacustom sort list example download
Data Validation - Custom Formulas
Dynamic Sheet Reference (INDIRECT)indirect dynamic sheet example download
Reference Cell in Another Sheet or Workbookreference cell in another sheet workbook example download
Get Cell Value by Addressget cell value by address row column example download
Get Worksheet Nameget sheet name example download
Increment Cell Referenceincrement cell reference example download
List Sheet Nameslist sheet names example download
List Skipped Numbers in Sequencelist skipped numbers in sequence example download
Return Address of Max Value in Rangereturn address highest value in range example download
Search by Keywordssearch by keywords example download
Select Every Other (or Every nth) Rowselect every nth row example download
Basicsyes
Cell Reference Basics - A1, R1C1, 3d, etc.
Add Up (Sum) Entire Column or Row
Into to Dynamic Array Formulasintroduction to dynamic array formulas example download
Conversionsyes
Convert Time Zonesconvert time zones example download
Convert Celsius to Fahrenheitconvert celsius to fahrenheit example download
Convert Pounds to Kilogramsconvert pounds to kilograms example download
Convert Time to Unix Timeconvert time to unix times example download
Convert Feet to Metersconvert feet to meters example download
Convert Centimeters to Inchesconvert centimetres to inches example download
Convert Kilometers to Milesconvert kilometers to miles example download
Convert Inches to Feetconvert inches to feet example download
Convert Date to Julian Formatconvert date to julian format example download
Convert Column Letter to Numberconvert column letter to number example download
Testsyes
Test if a Range Contains any Textrange contains any text example download
Test if any Cell in Range is Number
Test if a Cell Contains a Specific Value
Test if Cell Contains Any Numberif cell contains any number example download
Test if Cell Contains Specific Numberif cell contains number example download
Test if Cell is Number or Textcell is number text example download
Ifyes
Percentile If
Subtotal If
Sumproduct Ifsumproduct if example download
Large If and Small If
Median If
Concatentate Ifconcatenate if example download
Max Ifmax if with condition example download
Rank Ifrank if example download
TEXTJOIN Iftextjoin if example download
Sumyes
Sum if - Begins With / Ends Withsum if begins ends with example download
Sum if - Month or Year to Datesum if month year to date example download
Sum if - By Yearsum if year example download
Sum if - Blank / Non-Blanksum if blank example download
Sum if - Horizontal Sumsum if horizontal example download
Count / Sum If - Cell Colorcount sum cell color example download
INDIRECT Sumindirect sum example download
Sum If - Across Multiple Sheetssum if multiple sheets example download
Sum If - By Monthsum if month example download
Sum If - Cells Not Equal Tosum if not equal example download
Sum If - Not Blanksum if not blank example download
Sum if - Between Valuessum if between values example download
Sum If - Week Numbersum if week number example download
Sum Textsum text example download
Sum if - By Category or Groupsum if category group example download
Sum if - Cell Contains Specific Text (Wildcards)sum if contains text wildcards example download
Sum if - Date Rnagesum if date range example download
Sum if - Dates Equalsum if dates equal example download
Sum if - Day of Weeksum if day of week example download
Sum if - Greater Thansum if greater than example download
Sum if - Less Thansum if less than example download
Averageyes
Average Non-Zero Values
Average If - Not Blankaverage if not blank example download
Average - Ignore 0average ignore 0 example download
Average - Ignore Errorsaverage ignore errors example download
Mathyes
Multiplication Tablemultiplication table example download
Cube Rootscube root example download
nth Rootsnth root example download
Square Numberssquare numbers example download
Square Rootssquare roots example download
Calculationsyes
Calculate a Ratio
Calculate Age
KILLLLLLL
Calculate Loan Payments
GPA Formulagpa formula example download
Calculate VAT Taxcalculate vat tax example download
How to Grade Formulasgrade formulas example download
Findyes
Find a Number in a Column / Workbookfind number in column example download
Find Most Frequent Numbersfind most frequent numbers example download
Find Smallest n Valuesfind smallest n values example download
Find nth Occurance of Character in Textfind 2nd occurrence of character in text example download
Find and Extract Number from Stringfind extract number from string example download
Find Earliest or Latest Date Based on Criteriafind earliest latest date with criteria example download
Find First Cell with Any Valuefind first cell with any value example download
Find Last Rowfind last row example download
Find Last Row with Datafind last row with data example download
Find Missing Valuesfind missing values example download
Find Largest n Valuesfind largest n values example download
Most Frequent Numberfind most frequent numbers example download
Conditional Formattingyes
Conditional Format - Dates & Times
Conditional Format - Highlight Blank Cellshighlight blank cells conditional formatting example download