Excel functions, explained with examples
79 of the Excel functions people use most. Each page has a plain-English explanation, worked examples on real data, common mistakes and an FAQ.
No functions match “”. Try a single word such as lookup, date or text, or browse all functions and all guides.
Math
SUMAdds numbersAVERAGEMean of numbersMINSmallest numberMAXLargest numberMEDIANMiddle valuePRODUCTMultiplies numbersLARGEk-th largestSMALLk-th smallestROUNDRounds to digitsROUNDUPRounds away from zeroROUNDDOWNRounds toward zeroINTRounds down to integerABSAbsolute valueMODRemainder after divisionSQRTSquare rootPOWERRaises to a power
Counting
Conditional
Logic
Text
LEFTCharacters from the startRIGHTCharacters from the endMIDCharacters from the middleLENLength of textUPPERALL CAPSLOWERall lowercasePROPERCapitalize Each WordTRIMRemoves extra spacesCONCATJoins textCONCATENATEJoins text (older)TEXTJOINJoins with a separatorFINDPosition of text (case-sensitive)SEARCHPosition of textSUBSTITUTEReplaces textVALUEText to numberTEXTNumber to formatted text