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.
Engineering
Number bases, complex numbers, unit conversion and Bessel functions.
54 functions
BESSELIModified Bessel function In(x)BESSELJBessel function Jn(x)BESSELKModified Bessel function Kn(x)BESSELYBessel function Yn(x)BIN2DECConverts binary to decimalBIN2HEXConverts binary to hexadecimalBIN2OCTConverts binary to octalBITANDBitwise ANDBITLSHIFTShifts bits leftBITORBitwise ORBITRSHIFTShifts bits rightBITXORBitwise XORCOMPLEXBuilds a complex numberCONVERTConverts between unitsDEC2BINConverts decimal to binaryDEC2HEXConverts decimal to hexadecimalDEC2OCTConverts decimal to octalDELTA1 if two numbers are equalERFError functionERF.PRECISEError functionERFCComplementary error functionERFC.PRECISEComplementary error functionGESTEP1 if number ≥ stepHEX2BINConverts hexadecimal to binaryHEX2DECConverts hexadecimal to decimalHEX2OCTConverts hexadecimal to octalIMABSAbsolute value (modulus)IMAGINARYImaginary partIMARGUMENTAngle (argument) in radiansIMCONJUGATEComplex conjugateIMCOSCosineIMCOSHHyperbolic cosineIMCOTCotangentIMCSCCosecantIMCSCHHyperbolic cosecantIMDIVQuotientIMEXPExponentialIMLNNatural logarithmIMLOG10Base-10 logarithmIMLOG2Base-2 logarithmIMPOWERRaised to a powerIMPRODUCTProduct of complex numbersIMREALReal partIMSECSecantIMSECHHyperbolic secantIMSINSineIMSINHHyperbolic sineIMSQRTSquare rootIMSUBDifferenceIMSUMSum of complex numbersIMTANTangentOCT2BINConverts octal to binaryOCT2DECConverts octal to decimalOCT2HEXConverts octal to hexadecimal