# Functions H to L

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content

Functions H to L

| @cols=4:**Functions** |
| --------- | --------- | --------- | --------- |
| [HARMEAN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHARMEAN) | [HEX2BIN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHEX2BIN) | [HEX2DEC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHEX2DEC) | [HEX2OCT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHEX2OCT) |
| [HLOOKUP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHLOOKUP) | [HOUR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHOUR) | [HYPERLINK](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionHYPERLINK) | [HYPGEOM.DIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionHYPGEOM.DIST) |
| [HYPGEOMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHYPGEOMDIST) | [IF](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIF)  | [IFERROR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIFERROR) | [IFNA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIFNA) |
| [IFS](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIFS) | [IMABS](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMABS) | [IMAGE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/image-function) | [IMAGINARY](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMAGINARY) |
| [IMARGUMENT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMARGUMENT) | [IMCONJUGATE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMCONJUGATE) | [IMCOS](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMCOS) | [IMCOSH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMCOSH) |
| [IMCOT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMCOT) | [IMCSC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMCSC) | [IMCSCH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMCSCH) | [IMDIV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMDIV) |
| [IMEXP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMEXP) | [IMLN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMLN) | [IMLOG10](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMLOG10) | [IMLOG2](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMLOG2) |
| [IMPOWER](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMPOWER) | [IMPRODUCT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMPRODUCT) | [IMREAL](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMREAL) | [IMSEC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMSEC) |
| [IMSECH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMSECH) | [IMSIN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMSIN) | [IMSINH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMSINH) | [IMSQRT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMSQRT) |
| [IMSUB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMSUB) | [IMSUM](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIMSUM) | [IMTAN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIMTAN) | [INDEX](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINDEX) |
| [INDIRECT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionINDIRECT) | [INFO](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionsINFO) | [INT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINT) | [INTERCEPT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINTERCEPT) |
| [INTRATE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINTRATE) | [IPMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIPMT) | [IRR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIRR) | [ISBLANK](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISBLANK) |
| [ISERR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISERR) | [ISERROR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISERROR) | [ISEVEN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISEVEN) | [ISFORMULA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionISFORMULA) |
| [ISLOGICAL](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISLOGICAL) | [ISNA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISNA) | [ISNONTEXT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISNONTEXT) | [ISNUMBER](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISNUMBER) |
| [ISO.CEILING](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionISO.CEILING) | [ISODD](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISODD) | [ISOMITTED](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionIsomitted) | [ISOWEEKNUM](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionISOWEEKNUM) |
| [ISPMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISPMT) | [ISREF](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISREF) | [ISTEXT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionISTEXT) | [JIS](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionJIS) |
| [KURT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionKURT) | [LAMBDA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLambda) | [LARGE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLARGE) | [LCM](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLCM) |
| [LEFT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLEFT) | [LEFTB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLEFTB) | [LEN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLEN) | [LENB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLENB) |
| [LET](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLet) | [LINEST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLINEST) | [LN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLN) | [LOG](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOG) |
| [LOG10](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOG10) | [LOGEST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOGEST) | [LOGINV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOGINV) | [LOGNORM.DIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLOGNORM.DIST) |
| [LOGNORMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOGNORMDIST) | [LOOKUP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOOKUP) | [LOWER](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOWER) | [LOGNORM.INV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLOGNORM.INV) |
| [HBARSPARKLINE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionHBARSPARKLINE) | [HISTOGRAMSPARKLINE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionHISTOGRAMSPARKLINE) | [HSTACK](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/hstack-function) | [LINESPARKLINE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/functionLINESPARKLINE) |