Future Strategy Training Centre

11/10/2022

အိမ်ငှါးခရငွေ ကနေ အခွန်ဘယ်လောက် ဆောင်ရမလဲ
***********************************************

ဝင်ငွေ ရလမ်းအနေနဲ့ ပစ္စည်းငှါးရမ်းခ ရငွေ ခေါင်းစဉ်နဲ့ အကြုံးဝင်ပါတယ်

ပစ္စည်းလို့ ဆိုရာမှာ အဓိပ္ပါယ် သတ်မှတ်ချက်အရ မြေနဲ့ အဆောက်အဦး ပါဝင်ပါတယ်

မြေနှင့်အဆောက်အဦး ငှါးရမ်းခ ရငွေ အနေနဲ့ တစ်နှစ်စာ ဝင်ငွေမှ ထိုဝင်ငွေရရန် ကုန်ကျစရိတ်များ ၊ ဝင်ငွေခွန် ဥပဒေ ပုဒ်မ ၆အရ သက်သာခွင့်များ နှုတ်ပယ်ပြီး ကျန်ငွေ အပေါ် ၁၀ % အခွန်ထမ်းဆောင်ရပါမယ်

ဥပမာ တွက်ချက်ပြပါမယ်

ဦးမောင်မောင်သည် တစ်လ ၈သိန်းဖြင့် သူပိုင်ဆိုင်သော တိုက်ခန်းအား ရုံးခန်းဖွင့်မည့် လုပ်ငန်းတစ်ခုသို့ ငှါးရမ်းထားသည် ဆိုပါစို့

သူ့တွင် အတူနေ မိဘ ၂ဦးလုံး ရှိသည့်အပြင် အိမ်ထောက်ဘက် (မှီခို) အတူနေထိုင် ထောက်ပံ့ထားရပြီး အသက် ၁၈နှစ်အောက် သားသမီး ၂ဦးလည်း ရှိသည် ဆိုပါစို့

တွက်ချက်ပုံ
=========
ကျပ်
တစ်နှစ်စာ စုစုပေါင်း အိမ်ငှါးရမ်းခရငွေ (၈သိန်း x ၁၂ လ) ၉၆,၀၀,၀၀၀
အခြေခံ သက်သာခွင့် ၂၀% (၉၆၀၀၀၀၀ x ၂၀%) (၁၉,၂၀,၀၀၀)
-----------------------
၇၆,၈၀,၀၀၀

အတူနေမိဘ အတွက် သက်သာခွင့် (၁၀သိန်းx၂ဦး) ၂၀,၀၀,၀၀၀
အိမ်ထောင်ဘက်အတွက်သက်သာခွင့် ၁၀,၀၀,၀၀၀
သားသမီးအတွက် သက်သာခွင့် (၅သိန်းx၂ဦး) ၁၀,၀၀,၀၀၀ (၄၀,၀၀,၀၀၀)
----------------------- -----------------------
တစ်နှစ်တာအတွက် အခွန်စည်းကြပ်ရန် ဝင်ငွေ ၃၆,၈၀,၀၀၀

ကျသင့်အခွန် = အခွန်စည်းကြပ်ရန် ဝင်ငွေ x ၁၀% ၃,၆၈,၀၀၀

Original Creator - Tr.Daw Khin Thidar Zaw
Credit;

27/08/2022

📣အခေါ်အဝေါ်​တွေ ပြောင်းသွားပီ 😱
ကသခ ၃၁ တို့၊ Form 31 တို့ ​ခေါ်လို့မရ​တော့ဘူး​နော်။ ကသခ-၀၅-၀၁ လို့​​ခေါ်ရမယ်​နော် 👌

ပြည်တွင်းအခွန်များဦးစီးဌာန၏ ၂၂-၈-၂၀၂၂ရက်စွဲပါစာ ဖြင့် ယခင်အသုံးပြုသည့် ပုံစံများအားပယ်ဖျက်ပြီးယခုတင်ပြပါပူးတွဲပုံစံများအားသတ်မှတ်လိုက်ခြင်းဖြစ်ပါတယ်လို့ 👇

ယခင်ဝင-၁၇. ယခုဝင-၀၅-၀၁
ယခင်ကသခ-၃၁. ယခုကသခ-၀၅-၀၁
ယခင်ကသခ-၃၂. ယခုကသခ-၀၅-၀၂
ယခင်ကသခ-၃၃. ယခုကသခ-၀၅-၀၃
ယခင်အထခ-၂၀. ယခုအထခ-၀၅-၀၁
ယခင်အထခ-၂၁. ယခုအထခ-၀၅-၀၂
ယခင်အထခ-၂၂. ယခုအထခ-၀၅-၀၃


မူရင်း ပို့စ်ပိုင်ရှင်အား Credit ပေးပါသည်
Crd #

29/06/2022

09/06/2022

28/04/2022

2
does the depreciation start? current assets တွေကိုဘယ်အချိန်မှာစပြီးတော့ တန်ဖိုးလျော့တွတ်ချက်ရမလဲ?

ဥပမာ 1 January 2022
နေ့မှာလုပ်ငန်းသုံးဖို့ကား၀ယ်လိုက်တယ်😁ကားကလည်းလုပ်ငန်းထဲရောက်နေပြီ အသုံးပြုမယ်ဆိုသုံးလို့ရနေပြီ Initial measurement လည်းတွတ်ချက်ပြီးလို့ N.C.A အောက်မှာ Cost လည်းထဲ့ထားပြီးပြီ ဒါပေမဲ့အသုံးမပြုရသေးဘူး

1March 2022 နေ့ကစပြီးမှဒီကားကိုလုပ်ငန်းခွင်ထဲမှာစပြီးတော့အသုံးပြုတယ်ပေါ့

☆☆ဒီလိုဆိုတော့ N.C.A တွေကိုတန်ဖိုးလျော့ရတော့မယ်ဘယ်နေ့ကနေစပြီးလျော့ရမလဲ☆☆

💥အသုံးပြုတဲ့နေ့ကစပြီးလျော့ရမလား၊ ဒါမှမဟုတ်၀ယ်ယူတဲ့နေ့ကစပြီးလျော့ရမလားပေါ့💥

ကပြောထားတယ် 💥အသုံး ပြုလို့ရနေပြီဆိုရင်လျော့ပါ (Available for use) လို့ပြောထားတယ် ဒါကြောင့်၀ယ်ယူသည့် နေ့ 1January 2022 နေ့ကတည်းကအသုံးပြုလို့ရနေပြီဖြစ်တဲ့အတွက်ကြောင့် လုပ်ငန်းက အဲဒီနေ့ရက်တွေမှာသုံးသုံး မသုံးသုံး 1 January 2022 ကစပြီးတန်ဖိုးလျော့တွတ်ရပါမယ်

ကဲအခုလောက်ဆိုဘယ်အချိန်ကစတွတ်ရမလဲသိပြီပေါ့

measurement(၀ယ်ယူသည့်ကုန်ကျစရိတ် Capitalized Cost)မတွတ်တတ်သေးသောသူများအတွက်အောက်ကလင့်တွင်လေ့လာပါ

https://www.facebook.com/106202211406747/posts/250850260275274/

Future Strategy Training Centre

04/02/2022

All Formula Thinking & Approaching Tips
===========================


Count
Count between dates by age range
COUNTIFSFINDLEFTRIGHT
Count cells between dates
COUNTIFSDATE
Count cells between two numbers
COUNTIFSCOUNTIF
Count cells equal to
COUNTIF
Count cells equal to case sensitive
SUMPRODUCTEXACT
Count cells equal to either x or y
COUNTIF
Count cells equal to one of many things
COUNTIFSUMPRODUCTISNUMBERMATCH
Count cells greater than
COUNTIF
Count cells less than
COUNTIF
Count cells not between two numbers
COUNTIFSUMPRODUCT
Count cells not equal to
COUNTIF
Count cells not equal to many things
MATCHISNASUMPRODUCTCOUNTACOUNTIF
Count cells not equal to x or y
COUNTIFSSUMPRODUCT
Count cells over 100 characters
SUMPRODUCTLENN
Count cells that are blank
COUNTBLANKCOUNTA
Count cells that are not blank
COUNTACOUNTIFCOUNTIFS
Count cells that begin with
COUNTIFCOUNTIFS
Count cells that contain case sensitive
SUMPRODUCTISNUMBERFIND
Count cells that contain either x or y
COUNTIFSUMPRODUCTISNUMBERFIND
Count cells that contain errors
SUMPRODUCTISERRORISERRSUM
Count cells that contain five characters
COUNTIF
Count cells that contain negative numbers
COUNTIF
Count cells that contain numbers
COUNTSUMPRODUCT
Count cells that contain odd numbers
SUMPRODUCTMOD
Count cells that contain positive numbers
COUNTIF
Count cells that contain specific text
COUNTIFSUMPRODUCTFINDISNUMBER
Count cells that contain text
COUNTIFISTEXTSUMPRODUCTCOUNTIFS
Count cells that do not contain
COUNTIF
Count cells that do not contain errors
ISERRORNOTSUMPRODUCTISERR
Count cells that do not contain many strings
ISNUMBERSEARCHMMULTTRANSPOSE
Count cells that end with
COUNTIF
Count dates by day of week
SUMPRODUCTWEEKDAY
Count dates in given year
YEARSUMPRODUCT
Count if row meets internal criteria
SUMPRODUCT
Count if row meets multiple internal criteria
SUMPRODUCT
Count if two criteria match
COUNTIFSSUMPRODUCT
Count items in list
COUNTIFS
Count long numbers without COUNTIF
SUMPRODUCTCOUNTIF
Count matches between two columns
SUMPRODUCT
Count matching values in matching columns
SUMPRODUCTISNUMBERMATCHSEARCH
Count multiple criteria with NOT logic
SUMPRODUCTISNAMATCH
Count numbers by range with COUNTIFS
COUNTIFS
Count numbers that begin with
SUMPRODUCTLEFT
Count numbers third digit equals 3
SUMPRODUCTMID
Count occurrences in entire workbook
COUNTIFSUMPRODUCT
Count or sum variance
SUMPRODUCTSUMABS
Count or sum whole numbers only
MODSUMPRODUCT
Count paired items in listed combinations
COUNTIFSCONCAT
Count rows that contain specific values
MMULTCOLUMNTRANSPOSE
Count rows with at least n matching values
MMULTCOLUMNTRANSPOSE
Count rows with multiple OR criteria
SUMPRODUCT
Count rows with OR logic
SUMPRODUCT
Count sold and remaining
COUNTA
Count total matches in two ranges
SUMPRODUCTCOUNTIF
Count unique dates
UNIQUECOUNTCOUNTIFSUMPRODUCT
Count unique numeric values in a range
FREQUENCYSUMCOUNTIF
Count unique numeric values with criteria
FREQUENCYSUM
Count unique text values in a range
FREQUENCYMATCHROWSUMPRODUCT
Count unique text values with criteria
FREQUENCYMATCHROWSUM
Count unique values in a range with COUNTIF
SUMPRODUCTCOUNTIF
Count visible rows in a filtered list
SUBTOTAL
Count visible rows only with criteria
SUBTOTALOFFSETSUMPRODUCT
COUNTIF with non-contiguous range
COUNTIFINDIRECT
COUNTIFS with multiple criteria and OR logic
COUNTIFS
Histogram with FREQUENCY
FREQUENCY
Running count of occurrence in list
COUNTIF
Summary count by month with COUNTIFS
COUNTIFSEDATE
Summary count of non-blank categories
COUNTIFS
Summary count with COUNTIF
COUNTIF
Summary count with percentage breakdown
COUNTIFCOUNTA
SUMPRODUCT count multiple OR criteria
SUMPRODUCT
Two-way summary count with COUNTIFS
COUNTIFS
Sum
3D sum multiple worksheets
SUM
3D SUMIF for multiple worksheets
SUMPRODUCTSUMIFINDIRECT
Calculate running total
SUM
Subtotal by color
SUMIF
Subtotal by invoice number
SUMIFCOUNTIF
Subtotal invoices by age
SUMIF
Sum and ignore errors
SUMSUMIFAGGREGATEIFERROR
Sum bottom n values
SUMPRODUCTSMALLSUMROWINDIRECT
Sum bottom n values with criteria
SMALLSUM
Sum by group
SUMIF
Sum by month
SUMIFSEOMONTHSUMPRODUCTTEXT
Sum by month ignore year
SUMPRODUCTMONTH
Sum by month in columns
SUMIFSEOMONTH
Sum by week
SUMIFS
Sum by week number
SUMIFSWEEKNUM
Sum by weekday
SUMPRODUCTWEEKDAY
Sum columns based on adjacent criteria
SUMPRODUCT
Sum entire column
SUM
Sum every n rows
SUMOFFSET
Sum every nth column
SUMPRODUCTCOLUMNMOD
Sum first n matching values
FILTERSEQUENCEINDEXSUM
Sum formulas only
SUMPRODUCTISFORMULANOT
Sum if begins with
SUMIFSUMIFS
Sum if between
SUMIFS
Sum if by year
SUMIFSDATE
Sum if cell contains text in another cell
SUMIFSUMIFS
Sum if cells are equal to
SUMIFSUMIFS
Sum if cells are not equal to
SUMIFSUMIFS
Sum if cells contain an asterisk
SUMIFSUMIFS
Sum if cells contain both x and y
SUMIFS
Sum if cells contain either x or y
SUMIFSSUMPRODUCTISNUMBERFINDSEARCH
Sum if cells contain specific text
SUMIFSUMIFS
Sum if date is between
SUMIFSDATE
Sum if date is greater than
SUMIFSUMIFSDATE
Sum if ends with
SUMIFSUMIFS
Sum if equal to either x or y
SUMIFSUMPRODUCT
Sum if equal to one of many things
SUMIFSUMPRODUCTISNUMBERMATCH
Sum if greater than
SUMIFSUMIFS
Sum if less than
SUMIFSUMIFS
Sum if multiple criteria
SUMIFS
Sum if not blank
SUMIFSUMIFS
Sum if one criteria multiple columns
SUMPRODUCT
Sum last n columns
INDEXCOLUMNSUM
Sum matching columns
SUMPRODUCTLEFT
Sum matching columns and rows
SUMPRODUCT
Sum sales in last 30 days by ID
SUMIFSTODAY
Sum through n months
OFFSETSUM
Sum top n values
SUMPRODUCTLARGESUMROWINDIRECT
Sum top n values with criteria
SUMPRODUCTLARGE
Sum visible rows in a filtered list
SUBTOTAL
SUMIFS with horizontal range
SUMIFS
SUMIFS with multiple criteria and OR logic
SUMIFSSUM
SUMPRODUCT with IF
SUMPRODUCT
Average
Average and ignore errors
AVERAGEIFAGGREGATEAVERAGEIFERRORFILTER
Average by month
AVERAGEIFSEOMONTH
Average if criteria not blank
AVERAGEIFS
Average last 5 values
OFFSETCOUNTAVERAGE
Average last 5 values in columns
OFFSETCOUNTAVERAGE
Average numbers
AVERAGE
Average numbers ignore zero
AVERAGEIFAVERAGEIFS
Average pay per week
SUMPRODUCTCOUNTIF
Average response time per month
AVERAGEIFSEOMONTH
Average the last 3 numeric values
LOOKUPLARGEROWAVERAGEINDIRECT
Average top 3 scores
LARGEAVERAGE
Average with multiple criteria
AVERAGEIFS
Moving average formula
OFFSETAVERAGEMIN
Must pass 4 out of 6 subjects
IFCOUNTIFAND
Weighted average
SUMPRODUCTSUMAVERAGE
Dynamic array
Basic filter example
FILTER
Combine ranges
INDEXSEQUENCEROWSCOLUMNSLET
Count unique values
UNIQUECOUNTA
Count unique values with criteria
UNIQUEFILTERLENSUMCOUNTA
Detailed LET function example
LETVLOOKUPIFXLOOKUP
Distinct values
UNIQUE
Extract common values from two lists
FILTERCOUNTIFUNIQUESORT
Filter and transpose horizontal to vertical
FILTERTRANSPOSE
Filter by column, sort by row
FILTERSORT
Filter by date
FILTERMONTH
Filter contains one of many
FILTERISNUMBERMATCH
Filter data between dates
FILTER
Filter every nth row
FILTERSEQUENCEMODROW
Filter exclude blank values
FILTER
Filter horizontal data
FILTERTRANSPOSE
FILTER last n valid entries
FILTERSEQUENCEINDEX
FILTER on first or last n values
FILTERSEQUENCEINDEX
FILTER on top n values
FILTERLARGESORT
FILTER on top n values with criteria
FILTERLARGESORT
Filter text contains
FILTERSEARCHISNUMBER
Filter this or that
FILTER
Filter to extract matching values
FILTERCOUNTIFCOUNTIFS
FILTER to remove columns
FILTERMATCHISNUMBER
FILTER with complex multiple criteria
FILTERLEFTMONTHNOT
Filter with exact match
FILTERSEARCHISNUMBER
FILTER with multiple OR criteria
FILTERISNUMBERMATCH
FILTER with partial match
FILTERSEARCHISNUMBER
Generate random text strings
SORTBYRANDARRAYCOUNTASEQUENCECHAR
Get column totals
MMULTSEQUENCECOLUMNS
Get row totals
MMULTSEQUENCECOLUMNS
LAMBDA append range
LAMBDALETINDEXSEQUENCE
LAMBDA append range horizontal
LAMBDALETINDEXSEQUENCE
LAMBDA contains one of many
LAMBDASUMPRODUCTSUMISNUMBERSEARCH
LAMBDA contains which things
LAMBDALETISNUMBERSEARCHSORTBY
LAMBDA count words
LAMBDASUBSTITUTETRIMLEN
LAMBDA replace characters recursive
LAMBDALEFTMIDLEN
LAMBDA split text to array
LAMBDAFILTERXMLTRANSPOSE
LAMBDA strip characters
LAMBDALETMIDMATCHISNUMBER
LAMBDA strip trailing characters recursive
LAMBDAMIDLEN
List upcoming birthdays
SORTBYLETTEXTINDEXSEQUENCEXMATCH
Minimum value if unique
UNIQUEMINCOUNTIFIF
Random list of names
SORTBYRANDARRAYCOUNTASEQUENCE
Sequence of days
SEQUENCEWORKDAY.INTL
Sequence of months
SEQUENCEEDATEEOMONTH
Sequence of times
SEQUENCETIME
Sequence of years
SEQUENCEYEARMONTHDAY
Sort birthdays by month and day
SORTBYTEXT
Sort by custom list
SORTBYMATCH
Sort by one column
SORT
Sort by random
SORTBYRANDARRAYCOUNTA
Sort by two columns
SORTBY
Sort text by length
SORTBYLEN
Sort values by columns
SORTSORTBY
Unique rows
UNIQUESORT
Unique values
UNIQUE
Unique values by count
UNIQUEFILTERCOUNTIF
Unique values ignore blanks
UNIQUEFILTER
Unique values with criteria
UNIQUEFILTER
Unique values with multiple criteria
UNIQUEFILTER
UNIQUE with non-adjacent columns
FILTERUNIQUESORT
XLOOKUP match any column
MMULTSEQUENCECOLUMNS
Min and Max
Cap percentage between 0 and 100
MINMAXMEDIANIF
First in, last out times
MINIFSMAXIFSMAXIF
Large with criteria
LARGE
Larger of two values
MAX
Max of every nth column
MAXCOLUMNMOD
Max value ignore all errors
AGGREGATEMAXIFS
Max value in given month
MAXIFAGGREGATETEXTINDEXMATCH
Max value on given weekday
MAXIFAGGREGATE
Max value with variable column
INDEXMATCHMAXFILTERCOUNTIF
Maximum if multiple criteria
MAXIFMAXIFS
Maximum value
MAXMAXIFS
Maximum value if
MAXIFMAXIFS
Minimum difference if not blank
MINIFMINIFS
Minimum if multiple criteria
MINIFMINIFS
Minimum value
MIN
Minimum value if
MINIFMINIFS
Name of nth largest value
LARGEINDEXMATCHXLOOKUP
Name of nth largest value with criteria
LARGEINDEXMATCHIFXLOOKUP
nth largest value
LARGE
nth largest value with criteria
LARGE
nth largest value with duplicates
MAXIF
nth smallest value
SMALL
nth smallest value with criteria
SMALL
Smaller of two values
MIN
Lookup
Approximate match with multiple criteria
INDEXMATCHIF
Basic INDEX MATCH approximate
INDEXMATCH
Basic INDEX MATCH exact
INDEXMATCH
Basic Tax Rate calculation with VLOOKUP
VLOOKUP
Break ties with helper column and COUNTIF
SMALLINDEXMATCH
Calculate grades with VLOOKUP
VLOOKUP
Calculate shipping cost with VLOOKUP
VLOOKUP
Case sensitive lookup
EXACTINDEXMATCHXLOOKUP
Commission split formula example
VLOOKUP
Count missing values
COUNTIFSUMPRODUCTMATCHISNA
Exact match lookup with INDEX and MATCH
INDEXMATCHEXACT
Exact match lookup with SUMPRODUCT
SUMPRODUCTEXACT
Extract all matches with helper column
INDEXMATCHANDSUM
Extract all partial matches
INDEXAGGREGATEISNUMBERSEARCH
Extract multiple matches into separate columns
INDEXSMALLIFERRORROWCOLUMNS
Extract multiple matches into separate rows
INDEXSMALLIFERRORROWROWS
Faster VLOOKUP with 2 VLOOKUPS
VLOOKUPNA
Find closest match
INDEXMATCHABSMINXLOOKUP
Find longest string in column
INDEXMATCHMAXLEN
Find longest string with criteria
INDEXMATCHMAXLEN
Find lowest n values
SMALLINDEXMATCH
Find missing values
COUNTIFVLOOKUPMATCH
First match in range with wildcard
INDEXMATCH
Get address of lookup result
INDEXMATCHCELL
Get cell content at given row and column
ADDRESSINDIRECTINDEX
Get employee information with VLOOKUP
VLOOKUP
Get first match cell contains
INDEXMATCHISNUMBERSEARCHAGGREGATE
Get first non-blank value in a list
INDEXMATCHISBLANK
Get first text value in a list
VLOOKUP
Get first text value with HLOOKUP
HLOOKUP
Get information corresponding to max value
MAXMATCHINDEX
Get last match
INDEXMATCHMAXROW
Get last match cell contains
LOOKUPSEARCH
Get location of value in 2D array
SUMPRODUCTROWCOLUMN
Get nth match
SMALLIFMINROW
Get nth match with INDEX / MATCH
INDEXSMALL
Get nth match with VLOOKUP
VLOOKUPCOUNTIF
INDEX and MATCH descending order
INDEXMATCH
Index and match on multiple columns
MMULTCOLUMNTRANSPOSEINDEX
INDEX and MATCH with multiple criteria
INDEXMATCH
INDEX with variable array
INDEXMATCHCHOOSE
Join tables with INDEX and MATCH
INDEXMATCH
Left lookup with INDEX and MATCH
INDEXMATCH
Left lookup with VLOOKUP
VLOOKUPCHOOSE
Lookup and sum column
INDEXMATCHSUM
Lookup entire column
INDEXMATCH
Lookup entire row
INDEXMATCH
Lookup last file version
LOOKUPISNUMBERFIND
Lookup latest price
LOOKUP
Lookup lowest Monday tide
INDEXMATCHIFMINXLOOKUP
Lookup lowest value
INDEXMATCHMIN
Lookup up cost for product or service
VLOOKUP
Lookup value between two numbers
LOOKUP
Lookup with variable sheet name
VLOOKUPINDIRECT
Match first does not begin with
INDEXMATCHLEFT
Match first error
MATCHISERROR
Match first occurrence does not contain
INDEXMATCHISNUMBERSEARCH
Match long text
MATCHLEFTMIDEXACT
Match next highest value
INDEXMATCH
Max if criteria match
MAXIFMAXIFS
Merge tables with VLOOKUP
VLOOKUP
Multi-criteria lookup and transpose
INDEXMATCH
Multiple chained VLOOKUPs
VLOOKUPIFERROR
Multiple matches in comma separated list
TEXTJOIN
Nearest location with XMATCH
INDEXXMATCH
Next largest match with the MATCH function
INDEXMATCH
Partial match with numbers and wildcard
MATCHTEXT
Partial match with VLOOKUP
VLOOKUP
Position of first partial match
MATCHINDEX
Position of max value in list
MAXMATCH
Reverse VLOOKUP example
VLOOKUPCHOOSEINDEXMATCHXLOOKUP
Self-contained VLOOKUP
VLOOKUP
Sum lookup values using SUMIF
SUMIFSUMPRODUCT
Sum range with INDEX
INDEXSUM
SUMIFS multiple criteria lookup in table
SUMIFS
Two-way approximate match multiple criteria
INDEXMATCHIF
Two-way lookup with INDEX and MATCH
INDEXMATCH
Two-way lookup with VLOOKUP
VLOOKUPMATCH
VLOOKUP by date
VLOOKUP
VLOOKUP from another sheet
VLOOKUP
VLOOKUP from another workbook
VLOOKUP
VLOOKUP if blank return blank
VLOOKUPIF
VLOOKUP override output
VLOOKUP
VLOOKUP with 2 lookup tables
VLOOKUP
VLOOKUP with multiple criteria
VLOOKUP
VLOOKUP with numbers and text
VLOOKUPTEXTIFERROR
VLOOKUP with two client rates
VLOOKUP
VLOOKUP with variable table array
INDIRECTVLOOKUPIF
VLOOKUP without /A error
VLOOKUPIFERRORIFNA
XLOOKUP basic approximate match
XLOOKUP
XLOOKUP basic exact match
XLOOKUP
XLOOKUP case-sensitive
XLOOKUPEXACT
XLOOKUP date of max value
XLOOKUPINDEXMATCH
XLOOKUP horizontal lookup
XLOOKUP
XLOOKUP last match
XLOOKUP
XLOOKUP latest by date
XLOOKUPMAX
XLOOKUP lookup left
XLOOKUP
XLOOKUP lookup row or column
XLOOKUP
XLOOKUP match text contains
XLOOKUPSEARCHFINDISNUMBER
XLOOKUP rearrange columns
XLOOKUP
XLOOKUP two-way exact match
XLOOKUPINDEXMATCH
XLOOKUP wildcard match example
XLOOKUPTRANSPOSE
XLOOKUP with boolean OR logic
XLOOKUP
XLOOKUP with complex multiple criteria
FILTERLEFTMONTHNOT
XLOOKUP with logical criteria
XLOOKUP
XLOOKUP with multiple criteria
XLOOKUP
XMATCH reverse search
XMATCHINDEX
Zodiac sign lookup
INDEXMATCHTEXTDATEVALUEIFNAYEAR
If
If cell begins with x, y, or z
SUMCOUNTIF
If cell contains
IF
if cell contains this or that
COUNTIFSUM
If cell equals
IF
If cell is blank
IFISBLANK
If cell is greater than
IF
If cell is not blank
IFISBLANKNOT
If cell is this OR that
IFOR
If cell is x or y and z
IFORAND
If else
IF
If not blank multiple cells
IFISBLANKNOT
If NOT this or that
IFORNOT
If this AND that
IFAND
If this AND that OR that
IFANDOR
IF with boolean logic
IF
IF with other calculations
IFSUMANDAVERAGE
IF with wildcards
IF
Invoice status with nested if
IFTODAY
Nested IF function example
IF
Nested IF with multiple AND
IFANDOR
Only calculate if not blank
IFISBLANKCOUNTBLANKANDORCOUNT
Return blank if
IFISBLANKCOUNTBLANK
Show checkmark if complete
IFISBLANKNOT
Tax rate calculation with fixed base
IF
Two-tier sales tax calculation
IF
Win loss points calculation
VLOOKUPIF
Grouping
Categorize text with keywords
INDEXMATCHISNUMBERSEARCHXLOOKUP
Group arbitrary text values
VLOOKUP
Group numbers at uneven intervals
LOOKUP
Group numbers with VLOOKUP
VLOOKUP
Group times into 3 hour buckets
FLOOR
Group times into unequal buckets
VLOOKUP
If cell contains one of many things
INDEXMATCHISNUMBERSEARCH
Map inputs to arbitrary values
VLOOKUPCHOOSE
Map text to numbers
VLOOKUP
Running count group by n size
COUNTACEILING
Conditional formatting
Highlight 3 smallest values with criteria
SMALLAND
Conditional formatting based on another cell
Conditional formatting based on another column
Conditional formatting column is blank
ORANDNOT
Conditional formatting date past due
TODAY
Conditional formatting dates overlap
SUMPRODUCT
Conditional formatting highlight target percentage
Conditional formatting last n rows
Find duplicate values in two columns
COUNTIFAND
Gantt chart
AND
Gantt chart by week
AND
Gantt chart time schedule
ANDOR
Gantt chart with weekends
WEEKDAY
Highlight approximate match lookup conditional formatting
LOOKUPORAND
Highlight blank cells
ISBLANKLEN
Highlight bottom values
SMALL
Highlight cells that begin with
COUNTIFFINDIFERROR
Highlight cells that contain
SEARCHFINDISNUMBER
Highlight cells that contain one of many
SEARCHFINDISNUMBERSUMPRODUCT
Highlight cells that end with
COUNTIFRIGHTLENEXACT
Highlight cells that equal
EXACT
Highlight column differences
EXACTNOT
Highlight data by quartile
QUARTILE
Highlight dates between
DATEAND
Highlight dates greater than
DATE
Highlight dates in same month and year
DATETEXT
Highlight dates in the next N days
TODAYAND
Highlight dates that are weekends
WEEKDAYOR
Highlight duplicate columns
SUMPRODUCTCOUNTIF
Highlight duplicate rows
COUNTIFSCOUNTIFSUMPRODUCT
Highlight duplicate values
COUNTIF
Highlight entire rows
Highlight every other row
ISEVENISODDROWMOD
Highlight integers only
MOD
Highlight many matching values
COUNTIF
Highlight missing values
COUNTIF
Highlight multiples of specific value
MOD
Highlight numbers that include symbols
ISNUMBERMID
Highlight row and column intersection exact match
ORAND
Highlight rows that contain
SEARCHFIND
Highlight rows with blank cells
COUNTBLANK
Highlight rows with dates between
DATEAND
Highlight top values
LARGE
Highlight unique values
COUNTIF
Highlight unprotected cells
CELL
Highlight values between
AND
Highlight values greater than
Highlight values not between X and Y
ANDNOT
Shade alternating groups of n rows
ROWCEILINGISEVENISODD
Data validation
Data validation allow numbers only
ISNUMBER
Data validation allow text only
ISTEXT
Data validation allow uppercase only
UPPEREXACTAND
Data validation allow weekday only
YEARTODAY
Data validation date in next 30 days
ANDTODAY
Data validation date in specific year
YEARTODAY
Data validation don't exceed total
SUM
Data validation exists in list
COUNTIF
Data validation must begin with
EXACTLEFTCOUNTIF
Data validation must contain specific text
FINDISNUMBER
Data validation must not contain
ISNUMBERSEARCHSUMPRODUCT
Data validation must not exist in list
COUNTIF
Data validation no punctuation
FINDCOUNT
Data validation number multiple 100
MOD
Data validation only dates between
ANDDATE
Data validation require unique number
ANDISNUMBERCOUNTIF
Data validation specific characters only
MATCHCOUNTLENMIDINDIRECT
Data validation unique values only
COUNTIF
Data validation whole percentage only
TRUNCAND
Data validation with conditional list
IF
Rank
Rank function example
RANK
Rank if formula
COUNTIFSRANK
Rank race results
RANK
Rank values by month
LARGEINDEXMATCHTEXTIF
Rank with ordinal suffix
CHOOSEABSMOD
Rank without ties
RANKCOUNTIF
Round
Get decimal part of a number
TRUNC
Get integer part of a number
TRUNCINT
Get number at place value
MOD
Round a number
ROUND
Round a number down
ROUNDDOWN
Round a number down to nearest multiple
FLOOR
Round a number to n significant digits
ROUNDLOG10INTABS
Round a number to nearest multiple
MROUND
Round a number up
ROUNDUP
Round a number up to nearest multiple
CEILING
Round a number up to next half
CEILING
Round a price to end in .99
ROUNDMROUND
Round by bundle size
CEILING
Round price to end in .45 or .95
CEILING
Round time to nearest 15 minutes
MROUNDCEILINGFLOOR
Round to nearest 1000
ROUND
Round to nearest 5
MROUNDCEILINGFLOOR
Date and Time
Add business days to date
WORKDAYNETWORKDAYS
Add days exclude certain days of week
WORKDAY.INTL
Add days to date
DAY
Add decimal hours to time
TIMEMOD
Add decimal minutes to time
TIMEMOD
Add months to date
EDATE
Add workdays no weekends
WORKDAY.INTLNETWORKDAYS
Add workdays to date custom weekends
WORKDAY.INTLNETWORKDAYS
Add years to date
DATEYEARMONTHDAY
Assign points based on late time
IFVALUE
Basic timesheet formula with breaks
MOD
Calculate date overlap in days
MAXMIN
Calculate days open
TODAYIFISBLANK
Calculate days remaining
TODAY
Calculate expiration date
EOMONTHEDATE
Calculate number of hours between two times
IFMOD
Calculate retirement date
EDATEYEARFRACSIGN
Calculate years between dates
YEARFRACINT
Convert date string to date time
DATEVALUELEFTMIDTIMEVALUE
Convert date to Julian format
DATEYEARTEXT
Convert date to month and year
TEXT
Convert date to text
TEXT
Convert decimal hours to Excel time
Convert decimal minutes to Excel time
Convert decimal seconds to Excel time
Convert Excel time to decimal hours
Convert Excel time to decimal minutes
Convert Excel time to decimal seconds
Convert Excel time to Unix time
DATE
Convert text date dd/mm/yy to mm/dd/yy
DATELEFTMIDRIGHTTRIM
Convert text timestamp into time
TIMEMID
Convert text to date
DATELEFTMIDRIGHT
Convert time to money
Convert time to time zone
MOD
Convert Unix time stamp to Excel date
DATE
Count birthdays by month
SUMPRODUCTMONTH
Count calls at specific times
COUNTIFS
Count dates in current month
COUNTIFSEOMONTHSUMPRODUCTN
Count day of week between dates
WEEKDAYROWINDIRECTSUMPRODUCTSEQUENCE
Count holidays between two dates
SUMPRODUCT
Count times in a specific range
COUNTIFSTIME
Create date range from two dates
TEXTIF
Custom weekday abbreviation
WEEKDAYCHOOSE
Date is same month
MONTH
Date is same month and year
MONTHYEAR
Date is workday
WORKDAYWORKDAY.INTL
Days in month
DAYEOMONTH
Days until expiration date
Display the current date
TODAY
Display the current date and time
NOW
Due date by category
VLOOKUPWORKDAYXLOOKUP
Dynamic calendar grid
WEEKDAYCHOOSETODAY
Dynamic date list
TODAYROWS
Extract date from a date and time
INTTRUNC
Extract time from a date and time
MOD
Get age from birthday
DATEDIFTODAYDATEYEARFRACINT
Get date from day number
DATERIGHTLEFT
Get day from date
DAY
Get day name from date
TEXTWEEKDAYCHOOSE
Get days before a date
TODAY
Get days between dates
TODAYDAYS
Get days between dates ignoring years
DATEDIF
Get days, hours, and minutes between dates
INTTEXT
Get days, months, and years between dates
DATEDIFLET
Get earliest and latest project dates
MINIFSMAXIFSMINMAXIF
Get first day of month
DAYEOMONTH
Get first day of previous month
EOMONTH
Get fiscal quarter from date
MONTHCHOOSE
Get fiscal year from date
MONTHYEAR
Get last day of month
EOMONTHDATE
Get last weekday in month
EOMONTHWEEKDAY
Get last working day in month
WEEKDAYEOMONTH
Get Monday of the week
WEEKDAY
Get month from date
MONTHDATE
Get month name from date
MONTHCHOOSETEXT
Get months between dates
DATEDIF
Get most recent day of week
MOD
Get next day of week
WEEKDAY
Get next scheduled event
MINIFMINIFSINDEXMATCH
Get nth day of week in month
DAYWEEKDAY
Get nth day of year
DATEYEAR
Get percent of year complete
YEARFRACYEARDATE
Get project end date
WORKDAYWORKDAY.INTL
Get project midpoint
WORKDAYWORKDAY.INTL
Get project start date
WORKDAYWORKDAY.INTL
Get quarter from date
MONTHROUNDUP
Get same date next month
EDATE
Get same date next year
EDATE
Get week number from date
WEEKNUMISOWEEKNUM
Get work hours between dates
NETWORKDAYSNETWORKDAYS.INTL
Get work hours between dates and times
NETWORKDAYSNETWORKDAYS.INTL
Get work hours between dates custom schedule
MIDROWINDIRECTWEEKDAYSUMPRODUCT
Get workdays between dates
NETWORKDAYSNETWORKDAYS.INTL
Get year from date
YEAR
If Monday, roll back to Friday
WEEKDAYIF
Join date and text
TEXT
Last n days
ANDTODAY
Last n months
ANDTODAYEOMONTH
Last n weeks
ANDTODAYWEEKDAY
Last updated date stamp
TEXTTODAY
List holidays between two dates
TEXTJOINIF
Month number from name
MONTHDATEVALUE
Next anniversary date
EDATEDATEDIF
Next biweekly payday from date
CEILING
Next business day 6 months in future
WORKDAYWORKDAY.INTL
Next working day
WORKDAYWORKDAY.INTL
Pad week numbers with zeros
TEXTWEEKNUM
Parse time string to time
TIMERIGHTLEFTMID
Sum by fiscal year
MONTHYEARSUMPRODUCTSUMIF
Sum race time splits
SUM
Sum time by week and project
SUMIFS
Sum time over 30 minutes
SUMPRODUCTTIMESUMIFSCOUNTIFS
Sum time with SUMIFS
SUMIFS
Time difference in hours as decimal value
MOD
Time duration with days
TIME
Time since start in day ranges
IFSIF
Timesheet overtime calculation formula
MIN
Total hours that fall between two times
MINMAX
Workdays per month
NETWORKDAYSNETWORKDAYS.INTLEOMONTH
Working days in year
NETWORKDAYSNETWORKDAYS.INTLDATETODAY
Working days left in month
NETWORKDAYSNETWORKDAYS.INTLTODAY
Year is a leap year
DATEYEARMONTH
Date series
Series of dates by custom days
WORKDAY.INTL
Series of dates by day
Series of dates by month
DAYMONTHYEARDATEEOMONTH
Series of dates by weekends
WORKDAY.INTLWEEKDAY
Series of dates by workdays
WORKDAYNETWORKDAYS.INTLIFWEEKDAY
Series of dates by year
DAYMONTHYEARDATE
Text
Abbreviate names or words
TEXTJOINMIDROWCODELENINDIRECT
Add a line break with a formula
CHAR
Add line break based on OS
INFOCHAR
Capitalize first letter
LEFTMIDLEN
Cell contains all of many things
SUMPRODUCTISNUMBERSEARCHCOUNTA
Cell contains number
FINDCOUNT
Cell contains one of many things
SUMPRODUCTISNUMBERSEARCH
Cell contains one of many with exclusions
SUMPRODUCTISNUMBERSEARCH
Cell contains some words but not others
COUNTSEARCHAND
Cell contains specific text
SEARCHISNUMBERFIND
Cell contains which things
SEARCHISNUMBERFILTERTEXTJOIN
Cell equals one of many things
SUMPRODUCT
Clean and reformat telephone numbers
SUBSTITUTE
Compare two strings
EXACT
Conditional message with REPT function
REPTIFAND
Convert numbers to text
TEXT
Convert string to array
MIDROWLENINDIRECT
Convert text to numbers
VALUELEFTRIGHT
Count keywords cell contains
SUMPRODUCTMATCHISNUMBERSEARCH
Count line breaks in cell
LENSUBSTITUTECHARISBLANK
Count specific characters in a cell
LENSUBSTITUTEUPPER
Count specific characters in a range
LENSUBSTITUTEUPPERSUMPRODUCT
Count specific words in a cell
LENSUBSTITUTEUPPER
Count specific words in a range
LENSUBSTITUTEUPPERSUMPRODUCT
Count total characters in a cell
LEN
Count total characters in a range
LENSUMPRODUCT
Count total words in a cell
LENSUBSTITUTETRIM
Count total words in a range
SUMPRODUCTLENSUBSTITUTETRIM
Double quotes inside a formula
CHAR
Extract last two words from cell
MIDLENSUBSTITUTEFIND
Extract multiple lines from a cell
TRIMMIDSUBSTITUTEREPTLEN
Extract nth word from text string
TRIMMIDSUBSTITUTEREPTLEN
Extract substring
MID
Extract text between parentheses
MIDSEARCH
Extract word containing specific text
MIDMAXFINDSUBSTITUTEREPTTRIM
Extract word that begins with specific character
MIDLENFINDSUBSTITUTEREPTTRIM
Find and replace multiple values
SUBSTITUTEINDEX
Find nth occurrence of character
SUBSTITUTEFINDCHAR
Get first word
LEFTFINDISERROR
Get last line in cell
TRIMSUBSTITUTERIGHTREPTCHAR
Get last word
TRIMSUBSTITUTERIGHTREPT
Join cells with comma
TRIMSUBSTITUTETEXTJOIN
MAC address format
TEXTJOINSEQUENCEMID
Make words plural
IFIFNAVLOOKUP
Most frequent text with criteria
INDEXMATCHMODEIF
Most frequently occurring text
INDEXMATCHMODE
Normalize text
SUBSTITUTETRIMLOWER
Pad text to equal length
REPTLEN
Position of 2nd 3rd etc instance of character
SUBSTITUTEFIND
Remove characters from right
LEFTLENVALUE
Remove file extension from filename
LEFTFIND
Remove first character
REPLACERIGHTLENLEFT
Remove last word
MIDFINDSUBSTITUTELEN
Remove leading and trailing spaces from text
CLEANTRIMSUBSTITUTE
Remove line breaks
SUBSTITUTECLEAN
Remove text by matching
SUBSTITUTE
Remove text by position
REPLACE
Remove text by variable position
REPLACEFIND
Remove unwanted characters
SUBSTITUTECHARCODELEFT
Replace one character with another
SUBSTITUTE
Reverse text string
TEXTJOINMIDINDIRECTSEQUENCE
Sort comma separated values
FILTERXMLSUBSTITUTETEXTJOINSORT
Split dimensions into three parts
LEFTRIGHTMIDLENSUBSTITUTE
Split dimensions into two parts
SUBSTITUTELEFTRIGHTFIND
Split numbers from units of measure
MAXLEFTRIGHTISNUMBERVALUEMID
Split text and numbers
FINDMINRIGHTLEFT
Split text string at specific character
LEFTRIGHTLENFIND
Split text with delimiter
TRIMMIDSUBSTITUTEREPTLEN
Strip html from text or numbers
MIDLEN
Strip non-numeric characters
TEXTJOINMIDROWINDIRECT
Strip numeric characters from cell
TEXTJOINMIDROWINDIRECTSEQUENCELET
Text split to array
FILTERXMLSUBSTITUTETRANSPOSE
Translate letters to numbers
TEXTJOINVLOOKUPMIDROWT
Trim text to n words
LEFTSUBSTITUTEFIND
Financial
Annual compound interest schedule
FV
Annuity solve for interest rate
RATE
Bond valuation example
PVFVPRICE
CAGR formula examples
GEOMEANRRI
Calculate compound interest
FV
Calculate cumulative loan interest
CUMIPMT
Calculate cumulative loan principal payments
CUMPRINC
Calculate interest for given period
PPMT
Calculate interest rate for loan
RATE
Calculate loan interest in given year
CUMIPMT
Calculate original loan amount
PV
Calculate payment for a loan
PMT
Calculate payment periods for loan
NPER
Calculate periods for annuity
PMTPVFV
Calculate principal for given period
PPMT
Calculate simple interest
Compare effect of compounding periods
FV
Effective annual interest rate
EFFECTRRI
Estimate mortgage payment
PMTPVFV
Future value of annuity
FVPV
Future value vs. Present value
PVFV
Income tax bracket calculation
VLOOKUP
NPV formula for net present value
NPV
Payment for annuity
PMTPVFV
Present value of annuity
PVFV
Geometry
Area of a circle
PIPOWER
Area of a parallelogram
Area of a trapezoid
Area of a triangle
Circumference of a circle
PI
Distance formula
SQRT
Pythagorean theorem
Surface area of a cone
PIPOWER
Surface area of a cylinder
PIPOWER
Surface area of a sphere
PIPOWER
Volume of a cone
PIPOWER
Volume of a cylinder
PIPOWER
Volume of a rectangular prism
Volume of a sphere
PIPOWER
Workbook
Dynamic workbook reference
INDIRECT
Dynamic worksheet reference
INDIRECT
Get full workbook name and path
CELL
Get sheet name only
CELLMIDFIND
Get workbook name and path without sheet
CELLLEFTFINDSUBSTITUTELET
Get workbook name only
CELLMIDFINDLET
Get workbook path only
CELLLEFTFINDLET
Indirect named range different sheet
INDIRECT
List sheet index numbers
SHEET
List sheet names with formula
INDEXMIDROWNOWT
Worksheet name exists
ISREFINDIRECT
Internet
Create email address from name
LEFTLOWER
Create email address with name and domain
LEFTLOWER
Create email with display name
CONCATCONCATENATETEXTJOIN
Get domain from email address
RIGHTLENFIND
Get domain name from URL
LEFTFIND
Get name from email address
LEFTFIND
Get page from URL
TRIMRIGHTSUBSTITUTEREPT
Get top level domain (TLD)
RIGHTLENSUBSTITUTEFIND
Remove trailing slash from url
LENRIGHTLEFT
Strip protocol and trailing slash from URL
MIDRIGHTLENFIND
Names
Get first name from name
LEFTFIND
Get first name from name with comma
RIGHTLENFIND
Get last name from name
RIGHTLENSUBSTITUTEFIND
Get last name from name with comma
LENLEFT
Get middle name from full name
MIDLENTRIM
Join first and last name
CONCATENATE
Put names into proper case
PROPERTRIM
Percentage
Calculate percent variance
ABS
Decrease by percentage
Get amount with percentage
Get original number from percent change
Get original price from percentage discount
Get percent change
Get percentage discount
Get percentage of total
Get profit margin percentage
Get total from percentage
Increase by percentage
Percent of goal
Percent of students absent
Percent sold
Project complete percentage
COUNTA
Random
Random date between two dates
RANDBETWEENWORKDAY
Random number between two numbers
RANDBETWEEN
Random number from fixed set of options
CHOOSERANDBETWEEN
Random number weighted probability
RANDMATCHINDEX
Random text values
CHOOSERANDBETWEEN
Random times at specific intervals
RAND
Random value from list or table
INDEXRANDBETWEENROWS
Randomly assign data to groups
RANDBETWEENCHOOSE
Randomly assign people to groups
RANDROUNDUPCEILING
Range
Add row numbers and skip blanks
COUNTAIFISBLANK
Address of first cell in range
ADDRESSROWCOLUMNCELL
Address of last cell in range
ADDRESSROWCOLUMNROWSCOLUMNS
All cells in range are blank
SUMPRODUCT
All values in a range are at least
COUNTIFNOT
Count visible columns
CELLNSUM
COUNTIFS with variable range
COUNTIFSOFFSETADDRESSINDIRECTROW
Define range based on cell value
INDEXOFFSET
Dynamic named range with INDEX
INDEXCOUNTA
Dynamic named range with OFFSET
OFFSETCOUNTA
First column number in range
ROWSMIN
First match between two ranges
INDEXMATCHCOUNTIF
First row number in range
ROWMIN
Get address of named range
ADDRESSROWCOLUMNROWSCOLUMNS
Get relative column numbers in range
COLUMNSEQUENCECOLUMNS
Get relative row numbers in range
ROWSEQUENCEROWS
Last column number in range
COLUMNCOLUMNSMIN
Last n rows
ROWROWSINDEX
Last row in mixed data with blanks
MATCH
Last row in mixed data with no blanks
COUNTA
Last row in numeric data
MATCH
Last row in text data
MATCHREPT
Last row number in range
ROWROWSMIN
Multiple cells are equal
ANDEXACT
Multiple cells have same value
COUNTIF
Multiple cells have same value case sensitive
EXACTSUMPRODUCTCOUNTA
Multiple columns are equal
ANDCOUNTIF
Range contains a value not in another range
SUMPRODUCTMATCHISNA
Range contains numbers
SUMPRODUCTISNUMBER
Range contains specific date
COUNTIFSDATETODAY
Sequential row numbers
ROW
Total cells in a range
ROWSCOLUMNS
Total columns in range
COLUMNS
Total rows in range
ROWS
Tables
Automatic row numbers in Table
ROWINDEX
Average last N values in a table
INDEXAVERAGEROWS
Basic inventory formula example
SUMIFS
Count table columns
COLUMNS
Count table rows
ROWS
COUNTIFS with variable table column
COUNTIFSINDEXMATCHINDIRECT
Dynamic reference Table name
INDIRECT
Get column index in Excel Table
MATCH
Get column name from index in table
INDEX
Percentile IF in table
PERCENTILE
Running count in Table
INDEXSUM
Running total in Table
INDEXSUM
Sum multiple tables
SUM
SUMIFS vs other lookup formulas
SUMIFSINDEXMATCHLOOKUPXLOOKUPSUMPRODUCT
SUMIFS with Excel Table
SUMIFS
Two-way lookup VLOOKUP in a Table
VLOOKUPMATCH
Two-way summary with SUMIFS
SUMIFS
Errors
How to fix a circular reference error
How to fix the # # # # (hashtag) error
How to fix the ! error
IFERRORISERRORERROR.TYPE
How to fix the /0! error
IFERRORISERRORERROR.TYPE
How to fix the /A error
VLOOKUPIFERRORMATCH
How to fix the ? error
IFERRORISERRORERROR.TYPE
How to fix the ! error
IFERRORISERRORERROR.TYPE
How to fix the ! error
IFERRORISERRORERROR.TYPE
How to fix the ! error
ISREFIFERROR
How to fix the ! error
IFERRORISERRORERROR.TYPE
How to fix the ! error
IFERRORISERRORERROR.TYPE
Miscellaneous
Abbreviate state names
VLOOKUPINDEXMATCH
All dates in chronological order
IFSUMPRODUCTSORT
Basic array formula example
MAXMIN
Basic attendance tracking formula
COUNTIF
Basic error trapping example
IFERROR
Basic in cell histogram
REPTCHAR
Basic numeric sort formula
RANKCOUNTIF
Basic outline numbering
COUNTAMIDFINDLEN
Basic text sort formula
RANKCOUNTIF
BMI calculation formula
CONVERTPOWER
Build hyperlink with VLOOKUP
HYPERLINKVLOOKUP
Calculate a ratio from two numbers
GCD
Calculate win loss tie totals
SUMPRODUCT
Cap percentage at 100
MIN
Cap percentage at specific amount
MIN
Carry-on baggage Inches to centimeters
CONVERT
Cash denomination calculator
SUMPRODUCTINTFLOOR
Celsius to Fahrenheit conversion
CONVERT
Change negative numbers to positive
ABS
Check register balance
IFANDISBLANK
Coefficient of variation
STDEV.PSTDEV.SAVERAGE
Conditional median with criteria
MEDIAN
Conditional mode with criteria
MODE
Convert column letter to number
COLUMNINDIRECT
Convert column number to letter
ADDRESSSUBSTITUTE
Convert expense time units
INDEXMATCH
Convert feet and inches to inches
LEFTFINDMIDSUBSTITUTE
Convert inches to feet and inches
INTMODTRUNCABS
Convert pounds to kilograms
CONVERT
Copy value from every nth column
OFFSETCOLUMN
Copy value from every nth row
OFFSETROW
Cost of living adjustment
Count consecutive monthly orders
FREQUENCYMAXIF
Count values out of tolerance
SUMPRODUCTABS
Count with repeating values
ROUNDUPCOLUMNROW
Course completion status summary
COUNTIFS
Course completion summary with criteria
COUNTIFS
Create array of numbers
INDIRECTROW
Cube root of number
POWER
Customer is new
COUNTIFS
Display sorted values with helper column
INDEXMATCHROWS
Dropdown sum with all option
SUMIFSUMIF
Easy bundle pricing with SUMPRODUCT
SUMPRODUCT
Expense begins on specific month
IF
Extract unique items from a list
INDEXMATCHCOUNTIFLOOKUP
Filter values in array formula
ISNUMBERMATCH
Find and retrieve missing values
INDEXMATCHISNA
Fixed value every N columns
MODCOLUMN
Flag first duplicate in a list
COUNTIFCOUNTIFS
Flip table rows to columns
TRANSPOSE
Force negative numbers to zero
MAX
Forecast vs actual variance
SUMIFS
Formula with locked absolute reference
INDIRECT
Get date associated with last entry
LOOKUP
Get first entry by month and year
INDEXMATCHTEXT
Get last entry by month and year
LOOKUPTEXT
Get pivot table grand total
GETPIVOTDATA
Get pivot table subtotal
GETPIVOTDATA
Get pivot table subtotal grouped date
GETPIVOTDATA
Get value of last non-empty cell
LOOKUP
Hyperlink to first blank cell
HYPERLINKCELLINDEXMATCH
Hyperlink to first match
HYPERLINKCELLINDEXMATCH
Increment a calculation with ROW or COLUMN
ROWCOLUMN
Increment a number in a text string
RIGHTTEXT
Increment cell reference with INDIRECT
INDIRECTCELL
Leave a comment in a formula
N
Link to multiple sheets
HYPERLINKCELLINDEXMATCH
List contains duplicates
SUMPRODUCTCOUNTIF
List most frequently occuring numbers
MODEISNUMBERMATCH
Longest winning streak
FREQUENCYMAXIF
Lookup last file revision
SEARCHISERRORMAXINDEXIFROW
Mark rows with logical tests
COUNTIFSIF
Most frequently occurring number
MODE
Multiplication table formula
New customers per month
COUNTIFSEOMONTH
Nightly hotel rate calculation
SUMPRODUCTFILTERINDEXMATCH
Normalize size units to Gigabytes
MATCHLEFTRIGHT
nth root of number
POWER
Number is whole number
MODTRUNCINT
Odometer gas mileage log
SUMMAXMIN
One or the other not both
XOR
Pad a number with zeros
TEXTREPT
Parse XML with formula
FILTERXML
Random sort formula
INDEXMATCH
Range contains one of many substrings
SUMPRODUCTCOUNTIF
Range contains one of many values
SUMPRODUCTISNUMBERSEARCH
Range contains specific text
COUNTIF
Repeat fixed value every 3 months
MODDATEDIF
Return array with INDEX function
INDEXMATCHN
Reverse a list or range
INDEXCOUNTAROWSORTBYSEQUENCE
Risk Matrix Example
INDEXMATCH
Score quiz answers with key
SUMCOUNTA
Search entire worksheet for value
COUNTIF
Search multiple worksheets for value
COUNTIFINDIRECT
Send email with formula
HYPERLINK
Show formula text with formula
FORMULATEXTIFERRORISFORMULA
Simple currency conversion
VLOOKUPINDEXMATCH
Sort and extract unique values
MMULTTRANSPOSEINDEXMATCH
Sort numbers ascending or descending
SMALLLARGE
Sort text and numbers with formula
RANKCOUNTIFCOUNT
Split payment across months
AND
Square root of number
SQRTPOWERABS
Standard deviation calculation
STDEV.PSTDEV.SSTDEVSTDEVP
Student class enrollment with table
IFCOUNTIF
Sum every 3 cells
OFFSETCOLUMN
Sum Roman numbers
ARABICROMANSUMPRODUCTSUM
Sum text values like numbers
INDEXMATCHN
Transpose table without zeros
TRANSPOSEIF
Validate input with check mark
IFCOUNTIF
Value exists in a range

COUNTIFMATCH
Value is between two numbers
ANDMAXMIN
Value is within tolerance
IFABS
Volunteer hours requirement calculation
ANDCOUNTIFSUM