Search our ever-growing formula list to find the formula example that meets your needs.
IFERROR formulas
Random-groups
Excel-case-sensitive-lookup
AVERAGEIFS
Quarter-from-date
Compare-two-columns
Pull matching items
Excel match(total -index) sheet pi
Average-if-not-blank
Matches row-by-row
DUPLICATES VALUE & SPARKLINES
Compare 2 columns
Project-Timeline
Excel line sheet
Dublicate & unique
Combine-first-last-names
Project-Management
kg-to-lbs
Drop-down-list
Combine-cells-comma
years-of-service
double-nested-xlookup-dynamic-columns
AVERAGE IF OR
CODING
Years-between-dates
Project-Budgeting
Event-Budget
Cm-to-inches
YEAR SELLING DATA
Auto-populate-dates
MARKSHEET WITH PERCENTAGE CHART
District3
Clean-format-phone-numbers
xlookup-text
Employee-Performance
Profit loss
Check-mark
Automated-invoice
xlookup-return-blank-not-zero
District2
IS ERROR VLOOKUP
CHECK BOX
Marketing-Plan
xlookup-multiple-criteria
Investment-annuity
ATTENDENCE SHEEET
Inventory-Management
Total-number-of-cells-in-range
Total-cells-in-table
Top-bottom rules
To-Do-List
Time-sheet
Time-format-show-minutes-seconds
Find-duplicates-vlookup-match
Time-difference-hours-minutes-seconds
Find-2nd-occurrence-of-character-in-text
Time-difference
Product-codes
FEEES STATUS
Prevent-duplicate-entries
Extract-text-from-cell
Timecard-Template-with-Breaks2
Multiple sets of OR conditions
Create-date-range
Extract-text-between-characters-parenthesis
Multiple results
Extract-text-before-after-character
Payroll-Management
Count with OR conditions
Count-words-in-cell
Extract-last-word
Time Card
Multiple columns-partial match
Business-Acquisition-Worksheet
Sum Vlookup
PAYROLL
Convert-time-zones
Extract-day-from-date
Pie-chart
Count-unique-values-in-range
Multiple columns – full match
Sum function mathods
Pareto-chart
Convert-time-to-unix-times
Expense-Report
Budget-limit
PIC COLUMN CHART
MS Excel Attendance Register
Convert-time-to-seconds
Subtract Workday
Bmi-calculator
OVERFLOW FORMULA OF TARGET
Count-total-characters-column
Convert-time-to-minutes
STUDENT I CARD
Subtract days
Count-times-word-appears-in-cell
Monthly-Calendar
Convert-time-to-hours
Outlining-data
Student enquiry
BILL
Subtotal-if
STUDENT DETAILS VLOOKUP
Subtotal
Monthly sales
Convert-text-to-date
Startup-Expenses
SUBTOTAL ROUND
Personal-Budget
Convert-text-number
Count-specific-characters-column
Square-roots
MONTHLY SALES REPORT
Substitute-multiple-values
Average-time
Convert-state-name-abbreviation
PERCENTAGE COUNT IFERROR
Offset
Average-ignore-errors
Square-numbers
Nested IFERROR
Count-if-multiple-criteria
Split-text-space-comma
Monthly family meal planner1
Split-date-time
Average-ignore-0
Count-if-cells-in-range
Split
Sparklines
Capitalize-first-letter (1)
CALL STATISTICS
xlookup-date
VLOOKUP 2.0
Vlookup 2 values
Workdays-left-month-year
CALCULATION OF INTEREST
Workdays-in-month
Vlookup-return-blank-not-zero
VLOOKUP (1)
Attendence Conditional Formating
Calculate-vat-tax
Round average
Wildcard-characters
Assign-number-value-to-text
Using sum fonctions
Risk-score-bucket-vlookup
COUNTIF with OR and AND logic
What-if-analysis
Vlookup-na-error
Calculate-percentage-change-between-numbers
Use-cell-value-in-formula
COUNTIF SHEET
Vlookup-match-combined
Weeks-between-dates
Countdown-remaining-days
Vlookup-letter-grades
Two sets of OR conditions
Calculate-loan-payments-in-excel-google-sheets
Count-cells-with-any-text
Vlookup-indirect
Weekday-abbreviations
Vlookup-Hlookup-combined
Count-cells-that-contain-specific-text
Calculate-hours-worked
Salary Break up calculator
Vlookup-dynamic-column-reference2
Reverse-Vlookup-right-to-left
Travel-Itinerary
Wedding-Checklist
Calculate-hours-between-times
Running-count-of-occurrences-in-excel-and-google-sheets
Vlookup-dynamic-column-reference
Reverse-text
Round-to-nearest
Vlookup-duplicate-values
Count-cells-not-equal-to
Business-Plan-Template
Total-time
Reverse-list-range
Vlookup-Sum-Sumif
Vlookup-contains-partial-match
Count-cells-equal-two-results
Round-time
Round-significant-figures
Count-cells-do-not-contain
Return-address-highest-value-in-range
Count-cells-between-two-numbers
RESULT
Round-Price
Round-Percentages
RESULT WITH IF,OR FAIL
Round-nearest
Count-blank-non-blank-cells
REPORT CARD EXCEL SHEET
Add-minutes-to-time
Add-leading-zeros
AMRIT APRTMENT
Add-hours-time
Vlookup-Concatenate
ADVANCE FILTER
DATE OF BIRTH TOTAL DAY
Add-Comma
vlookup-case-sensitive
ADHYAYAN CALENDER
vlookup-between-sheets
Add Workday
District
Add-subtract-weeks-to-date
Data-tables
decrease-by-percentage
Vlookup with nested Iferror
decimal-part-of-number
Add Dates
Add-spaces-to-cell
DATA FILTER
Days-between-dates
Day-number-of-year
Add-seconds-to-time
2-way Vlookup
Day-name-from-date
Vlookup Nth instance
DATA ENTRY
Date-to-number
& operator
Vlookup multiple criteria
DATA BARS
DATE-Serial-number
Daily-Planner
VLOOKUP calculations
Vlookup and Sumif
Cube-root
CRM
Vlookup 2nd instance
remove-unwanted-characters
remove-specific-text-cell
remove-non-numeric-characters
remove-last-chars-from-right
remove-extra-trailing-leading-spaces
reject-invalid-dates
reference-cell-in-another-sheet
Sequential lookups
separate-text-numbers
separate-first-last-names
search-by-keywords
Spaces, commas, etc.
Scatter-Plot
sort-with-small-large-function
Sales Repot
sort-two-columns
Social-Media-Report
Simple-Invoice
SALES & PROFIT REPORT
Simple-Budget
SIMPLE LOAN CALCULARATOR
salary-slip
SHARMA HOUSE COMPOUND
Services-Invoice
Sequential Vlookups
Wrap Text
Vlookup
Upper
Trim
Text To Column
Text that contains
Text Lenght
Sumif & Sumifs
Sum
sum function mathods
Subtraction
Round
Right
Remove Duplicate
Proper
Profit loss’
Pivot
Pi Chart
Oriantation
Multiplication
Mid
Merge & Center
Max & Min
Match Index
Marksheet
Lower
Less Than
Lenght
Left
Is Text
Is Odd
Is Number
Is Even
Hlookup
Greater Than
Grade
Freeze Panes
Flash Fill
Filter
Exact
Equal
Employee (SALARY SHEET)
Dublicate & Unique
Division
Datedif
Date Occurring
Data Validation
Data Bars
Count, CountA
Concatenate
Comment
Chart
Category formula
Bill book
Between
Attendence Sheet
Arithmetic Operator
AND, OR
Addition
ABS
Add (Subtract) Days to a Date
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