Search:

• Search Results

Learing Excel Formula

• Excel Formulas List
  • DATE
    • 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
    • Extract Day from Date
    • 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
    • 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
    • Add Commas to Cells
    • Get First Word from Text
    • Capitalize First Letter
    • Clean & Format Phone #s
    • Remove Extra Trailing / Leading Spaces
    • 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
    • Extract Text From Cell
    • Get Last Word
    • Remove Unwated Characters
    • Extract Text Before or After Character
    • 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
    • Extract Text Between Characters (Ex. Parenthesis)
    • 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
    • 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
    • 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
    • Count if Value Exists
    • Running Count of Occurrences
  • LOOKUP
    • 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.
    • 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
    • Cell Reference Basics - A1, R1C1, 3d, etc.
    • Add Up (Sum) Entire Column or Row
    • Into to Dynamic Array Formulas
  • CONVERSIONS
    • 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
    • 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
    • Percentile If
    • Subtotal If
    • Sumproduct If
    • Large If and Small If
    • Median If
    • Concatentate If
    • Max If
    • Rank If
    • TEXTJOIN If
  • SUM
    • 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
    • Average Non-Zero Values
    • Average If - Not Blank
    • Average - Ignore 0
    • Average - Ignore Errors
  • MATH
    • Multiplication Table
    • Cube Roots
    • nth Roots
    • Square Numbers
    • Square Roots
  • CALCULATIONS
    • Calculate a Ratio
    • Calculate Age
    • KILLLLLLL
    • Calculate Loan Payments
    • GPA Formula
    • Calculate VAT Tax
    • How to Grade Formulas
  • FIND
    • Find a Number in a Column / Workbook
    • Find Most Frequent Numbers
    • Find Smallest n Values
    • Find nth Occurance of Character in Text
    • Find and Extract Number from String
    • 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
    • Conditional Format - Dates & Times
    • Conditional Format - Highlight Blank Cells