100 everyday Excel formulas with examples
100 everyday Excel formulas in 10 groups, one page each, from SUM, IF, VLOOKUP and XLOOKUP to date, text and finance functions. Every page shows the syntax, a worked example table with the result, how the formula reads and what it is good for.
➕ Basics: 12 formulas
SUMSUM➕ Add up numbersAVERAGEAVERAGE➕ AverageMINMIN➕ Smallest valueMAXMAX➕ Largest valueCOUNTCOUNT➕ Count numbersCOUNTACOUNTA➕ Count non-empty cellsCOUNTBLANKCOUNTBLANK➕ Count blank cellsROUNDROUND➕ RoundROUNDUPROUNDUP➕ Round upROUNDDOWNROUNDDOWN➕ Round downINTINT➕ Whole number partABSABS➕ Absolute value
🧮 Math: 8 formulas
MODMOD🧮 RemainderPOWERPOWER🧮 PowerSQRTSQRT🧮 Square rootPRODUCTPRODUCT🧮 Multiply allSUMPRODUCTSUMPRODUCT🧮 Multiply pairs and addRANDRAND🧮 Random 0 to 1RANDBETWEENRANDBETWEEN🧮 Random whole numberCEILING.MATHCEILING.MATH🧮 Round up to a step
🔀 Logic: 14 formulas
IFIF🔀 If this, then thatIFSIFS🔀 Several conditionsANDAND🔀 All must be trueOROR🔀 Any one trueNOTNOT🔀 Reverse true/falseIFERRORIFERROR🔀 Replace errorsIFNAIFNA🔀 Replace not-foundSWITCHSWITCH🔀 Pick by valueSUMIFSUMIF🔀 Sum with a conditionSUMIFSSUMIFS🔀 Sum with several conditionsCOUNTIFCOUNTIF🔀 Count with a conditionCOUNTIFSCOUNTIFS🔀 Count with several conditionsAVERAGEIFAVERAGEIF🔀 Average with a conditionAVERAGEIFSAVERAGEIFS🔀 Average with several conditions
📊 Stats and ranking: 8 formulas
MAXIFSMAXIFS📊 Largest with a conditionMINIFSMINIFS📊 Smallest with a conditionLARGELARGE📊 n-th largestSMALLSMALL📊 n-th smallestRANK.EQRANK.EQ📊 RankMEDIANMEDIAN📊 MedianMODE.SNGLMODE.SNGL📊 Most common valueSUBTOTALSUBTOTAL📊 Total of visible rows
🔎 Lookup: 12 formulas
INDIRECTINDIRECT🔎 Reference from textROWROW🔎 Row numberCOLUMNCOLUMN🔎 Column numberHYPERLINKHYPERLINK🔎 Make a linkVLOOKUPVLOOKUP🔎 Vertical lookupHLOOKUPHLOOKUP🔎 Horizontal lookupXLOOKUPXLOOKUP🔎 Modern lookupINDEXINDEX🔎 Value at a positionMATCHMATCH🔎 Find the positionXMATCHXMATCH🔎 Modern position searchCHOOSECHOOSE🔎 Pick from a listOFFSETOFFSET🔎 Shifted range
⚡ Dynamic arrays: 8 formulas
FILTERFILTER⚡ Filter with a formulaUNIQUEUNIQUE⚡ Remove duplicatesSORTSORT⚡ SortSORTBYSORTBY⚡ Sort by another columnSEQUENCESEQUENCE⚡ Number sequenceTRANSPOSETRANSPOSE⚡ Swap rows and columnsLETLET⚡ Name parts of a formulaTEXTSPLITTEXTSPLIT⚡ Split text into cells
🔤 Text: 18 formulas
LEFTLEFT🔤 Left charactersRIGHTRIGHT🔤 Right charactersMIDMID🔤 Middle charactersLENLEN🔤 Count charactersFINDFIND🔤 Find position (case-sensitive)SEARCHSEARCH🔤 Find position (any case)TRIMTRIM🔤 Remove extra spacesCLEANCLEAN🔤 Remove odd charactersUPPERUPPER🔤 Upper caseLOWERLOWER🔤 Lower casePROPERPROPER🔤 Capitalise each wordSUBSTITUTESUBSTITUTE🔤 Replace textREPLACEREPLACE🔤 Replace by positionCONCATCONCAT🔤 Join textTEXTJOINTEXTJOIN🔤 Join with a separatorTEXTTEXT🔤 Format a number or dateVALUEVALUE🔤 Text to numberREPTREPT🔤 Repeat text
📅 Date and time: 12 formulas
TODAYTODAY📅 TodayNOWNOW📅 NowDATEDATE📅 Build a dateYEARYEAR📅 Year of a dateMONTHMONTH📅 Month of a dateDAYDAY📅 Day of a dateWEEKDAYWEEKDAY📅 Day of the weekEDATEEDATE📅 Add monthsEOMONTHEOMONTH📅 End of monthDATEDIFDATEDIF📅 Age, time betweenNETWORKDAYSNETWORKDAYS📅 Count working daysWORKDAYWORKDAY📅 Working day after
💰 Finance: 4 formulas
✅ Checks: 4 formulas
ISBLANKISBLANK✅ Is it blankISNUMBERISNUMBER✅ Is it a numberISTEXTISTEXT✅ Is it textISERRORISERROR✅ Is it an error
Function names and Excel versions follow Microsoft's function list · example tables match the Excel app in Thai Smiles
Updated 17 November 2026 · by Black Sheep Barn