# Functions M to Q

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 M to Q

| @cols=4:**Functions** |
| --------- | --------- | --------- | --------- |
| [MAKEARRAY](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMakearray) | [MAP](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMap) | [MATCH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMATCH) | [MAX](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMAX) |
| [MAXA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMAXA) | [MAXIFS](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMAXIFS) | [MDETERM](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMDETERM) | [MDURATION](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMDURATION) |
| [MEDIAN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMEDIAN) | [MID](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMID)  | [MIDB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMIDB) | [MIN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMIN) |
| [MINA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMINA) | [MINIFS](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMINIFS) | [MINUTE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMINUTE) | [MINVERSE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMINVERSE) |
| [MIRR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMIRR) | [MMULT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMMULT) | [MOD](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMOD) | [MODE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMODE) |
| [MODE.MULT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMODE.MULT) | [MODE.SNGL](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMODE.SNGL) | [MONTH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMONTH) | [MROUND](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMROUND) |
| [MULTINOMIAL](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMULTINOMIAL) | [MUNIT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMUNIT) | [N](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionN) | [NA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNA) |
| [NEGBINOM.DIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNEGBINOM.DIST) | [NEGBINOMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNEGBINOMDIST) | [NETWORKDAYS](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNETWORKDAYS) | [NETWORKDAYS.INTL](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNETWORKDAYS.INTL) |
| [NOMINAL](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNOMINAL) | [NORM.DIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNORM.DIST) | [NORM.INV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNORM.INV) | [NORM.S.DIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNORM.S.DIST) |
| [NORM.S.INV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNORM.S.INV) | [NORMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNORMDIST) | [NORMINV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNORMINV) | [NORM.DIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNORM.DIST) |
| [NORM.INV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNORM.INV) | [NOT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNOT) | [NOW](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNOW) | [NPER](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNPER) |
| [NPV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNPV) | [NUMBERVALUE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionNUMBERVALUE) | [OCT2BIN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionOCT2BIN) | [OCT2DEC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionOCT2DEC) |
| [OCT2HEX](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionOCT2HEX) | [ODD](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionODD) | [ODDFPRICE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionODDPRICE) | [ODDFYIELD](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionODDFYIELD) |
| [ODDLPRICE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionODDLPRICE) | [ODDLYIELD](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionODDLYIELD) | [OFFSET](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionOFFSET) | [OR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionOR) |
| [PDURATION](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPDURATION) | [PEARSON](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPEARSON) | [PERCENTILE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPERCENTILE) | [PERCENTILE.EXC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPERCENTILE.EXC) |
| [PERCENTILE.INC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPERCENTILE.INC) | [PERCENTRANK](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPERCENTRANK) | [PERCENTRANK.EXC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPERCENTRANK.EXC) | [PERCENTRANK.INC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPERCENTRANK.INC) |
| [PERMUT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPERMUT) | [PERMUTATIONA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPERMUTATIONA) | [PHI](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPHI) | [PI](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPI) |
| [PMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPMT) | [POISSON](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPOISSON) | [POISSON.DIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPOISSON.DIST) | [POWER](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPOWER) |
| [PPMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPPMT) | [PRICE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPRICE) | [PRICEDISC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPRICEDISC) | [PRICEMAT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPRICEMAT) |
| [PROB](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPROB) | [PRODUCT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPRODUCT) | [PROPER](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPROPER) | [PV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPV) |
| [QUARTILE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionQUARTILE) | [QUARTILE.EXC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionQUARTILE.EXC) | [QUARTILE.INC](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionQUARTILE.INC) | [QUOTIENT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionQUOTIENT) |
| [MONTHSPARKLINE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionMONTHSPARKLINE) | [PARETOSPARKLINE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPARETOSPARKLINE) | [PIESPARKLINE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/functionPIESPARKLINE) |  |