Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Math & trigonometry
Add, round, multiply and calculate: SUM, ROUND, SUMIFS, MOD and more. · 14 exercises
80 functions
ABSAbsolute valueACOSArccosine, in radiansACOSHInverse hyperbolic cosineACOTArccotangent, in radiansACOTHInverse hyperbolic cotangentAGGREGATELike SUBTOTAL, and can skip errorsARABICConverts Roman numerals to a numberASINArcsine, in radiansASINHInverse hyperbolic sineATANArctangent, in radiansATAN2Angle from x and y coordinatesATANHInverse hyperbolic tangentBASEConverts a number to another baseCEILING.MATHRounds up to a multipleCEILING.PRECISERounds up to a multipleCOMBINNumber of combinationsCOMBINACombinations with repetitionCOSCosine of an angle in radiansCOSHHyperbolic cosineCOTCotangentCOTHHyperbolic cotangentCSCCosecantCSCHHyperbolic cosecantDECIMALConverts text in a base to a numberDEGREESRadians to degreesEVENRounds up to an even numberEXPe raised to a powerFACTFactorial (n!)FACTDOUBLEDouble factorial (n!!)FLOOR.MATHRounds down to a multipleFLOOR.PRECISERounds down to a multipleGCDGreatest common divisorINTRounds down to a whole numberISO.CEILINGRounds up to a multipleLCMLeast common multipleLNNatural logarithmLOGLogarithm in any baseLOG10Base-10 logarithmMDETERMDeterminant of a square matrixMINVERSEInverse of a square matrixMMULTMatrix productMODRemainder after divisionMROUNDRounds to the nearest multipleMULTINOMIALMultinomial coefficientMUNITIdentity matrixODDRounds up to an odd numberPERCENTOFSubset as a share of the totalPIThe number πPOWERRaises to a powerPRODUCTMultiplies numbersQUOTIENTWhole-number part of a divisionRADIANSDegrees to radiansRANDRandom number between 0 and 1RANDARRAYArray of random numbersRANDBETWEENRandom whole number in a rangeROMANConverts a number to Roman numeralsROUNDRounds a numberROUNDDOWNRounds toward zeroROUNDUPRounds away from zeroSECSecantSECHHyperbolic secantSEQUENCEA list of numbersSERIESSUMSum of a power seriesSIGN1, 0 or -1 for the signSINSine of an angle in radiansSINHHyperbolic sineSQRTSquare rootSQRTPISquare root of number × πSUBTOTALSubtotal that skips other subtotalsSUMAdds numbersSUMIFAdds cells that meet a conditionSUMIFSAdds cells that meet several conditionsSUMPRODUCTSum of productsSUMSQSum of squaresSUMX2MY2Sum of x² − y²SUMX2PY2Sum of x² + y²SUMXMY2Sum of (x − y)²TANTangent of an angle in radiansTANHHyperbolic tangentTRUNCCuts off decimals