# Insert function

The ability to perform basic calculations is the principal reason for using a spreadsheet. Some of them are performed automatically when you select a range of cells in your spreadsheet:

- AVERAGE is used to analyze the selected range of cells and find the average value.
- COUNT is used to count the number of the selected cells containing values ignoring empty cells.
- SUM is used to add all the numbers in the selected range ignoring empty cells or those contaning text.

The results of these calculations are displayed in the right lower corner at the status bar.

To perform any other calculations you can insert a needed formula manually using the common mathematical operators or insert a predefined formula - Function.

To insert a function,

1. select a cell you wish to insert a function into,
2. click the Insert Function icon situated at the top toolbar and select one of the commonly used functions (SUM, MIN, MAX, COUNT) or click the Additional option,
   or right-click within a selected cell and select the Insert Function option from the menu,
   or click the icon before the formula bar,
3. in the Insert Function window that opens, select the necessary function group, then choose the function you need from the list and click OK.
4. enter the function arguments either manually or dragging to select a range of cells to be included as an argument. If the function requires several arguments, they must be separated by commas.

   Note: generally, numeric values, logical values (TRUE, FALSE), text values (must be quoted), cell references, cell range references, names assigned to ranges and other functions can be used as function arguments.

5. Press the Enter key.

Here is the list of the available functions grouped by categories:

Function Category | Description | Functions
Date and Time Functions | Are used to correctly display date and time in your spreadsheet. | DATE; DATEDIF; DATEVALUE; DAY; DAYS360; EDATE; EOMONTH; HOUR; MINUTE; MONTH; NETWORKDAYS; NOW; SECOND; TIME; TIMEVALUE; TODAY; WEEKDAY; WEEKNUM; WORKDAY; YEAR; YEARFRAC

Engineering Functions

Are used to perform some engineering calculations: converting between different bases, finding complex numbers etc.

BIN2DEC; BIN2HEX; BIN2OCT; COMPLEX; DEC2BIN; DEC2HEX; DEC2OCT; DELTA; ERF; ERFC; GESTEP; HEX2BIN; HEX2DEC; HEX2OCT; IMABS; IMAGINARY; IMARGUMENT; IMCONJUGATE; IMCOS; IMCOSH; IMCOT; IMCSC; IMCSCH; IMDIV; IMEXP; IMLN; IMLOG10; IMLOG2; IMPOWER; IMPRODUCT; IMREAL; IMSEC; IMSECH; IMSIN; IMSINH; IMSQRT; IMSUB; IMSUM; IMTAN; OCT2BIN; OCT2DEC; OCT2HEX

Text and Data Functions | Are used to correctly display the text data in your spreadsheet. | CHAR; CLEAN; CODE; CONCATENATE; CONCAT; DOLLAR; EXACT; FIND; FINDB; FIXED; LEFT; LEFTB; LEN; LENB; LOWER; MID; MIDB; NUMBERVALUE; PROPER; REPLACE; REPLACEB; REPT; RIGHT; RIGHTB; SEARCH; SEARCHB; SUBSTITUTE; T; TEXT; TRIM; UPPER; VALUE

Statistical Functions

Are used to analyze data: finding the average value, the largest or smallest values in a range of cells.

AVEDEV; AVERAGE; AVERAGEA; AVERAGEIF; AVERAGEIFS; BETADIST; BETA.DIST; BETA.INV; BINOMDIST; BINOM.DIST; BINOM.INV; CHIDIST; CHIINV; CHISQ.DIST; CHISQ.DIST.RT; CHISQ.INV; CHISQ.INV.RT; CONFIDENCE; CONFIDENCE.NORM; CONFIDENCE.T; CORREL; COUNT; COUNTA; COUNBLANK; COUNTIF; COUNTIFS; COVAR; CRITBINOM; DEVSQ; EXPON.DIST; EXPONDIST; F.DIST; FDIST; F.DIST.RT; F.INV; FINV; F.INV.RT; FISHER; FISHERINV; FORECAST; FREQUENCY; GAMMA; GAMMA.DIST; GAMMADIST; GAMMA.INV; GAMMAINV; GAMMALN; GAMMALN.PRECISE; GAUSS; GEOMEAN; HARMEAN; HYPGEOMDIST; INTERCEPT; KURT; LARGE; LOGINV; LOGNORM.DIST; LOGNORM.INV; LOGNORMDIST; MAX; MAXA; MEDIAN; MIN; MINA; MODE; NEGBINOMDIST; NORMDIST; NORMINV; NORMSDIST; NORMSINV; PEARSON; PERCENTILE; PERCENTILE.EXC; PERCENTILE.INC; PERCENTRANK; PERCENTRANK.EXC; PERCENTRANK.INC; PERMUT; POISSON; PROB; QUARTILE; RANK; RANK.AVG; RANK.EQ; RSQ; SKEW; SLOPE; SMALL; STANDARDIZE; STDEV; STDEVA; STDEVP; STDEVPA; STEYX; TDIST; T.DIST; T.DIST.2T; T.DIST.RT; T.INV; T.INV.2T; TINV; VAR; VARA; VARP; VARPA

Financial Functions

Are used to perform some financial calculations calculating the net present value, payments etc.

ACCRINT; ACCRINTM; AMORDEGRC; AMORLINC; COUPDAYBS; COUPDAYS; COUPDAYSNC; COUPNCD; COUPNUM; COUPPCD; CUMIPMT; CUMPRINC; DB; DDB; DISC; DOLLARDE; DOLLARFR; DURATION; EFFECT; FV; FVSCHEDULE; INTRATE; IPMT; IRR; ISPMT; MDURATION; MIRR; NOMINAL; NPER; NPV; ODDFPRICE; ODDFYIELD; ODDLPRICE; ODDLYIELD; PMT; PPMT; PRICE; PRICEDISC; PRICEMAT; PV; RATE; RECEIVED; SLN; SYD; TBILLEQ; TBILLPRICE; TBILLYIELD; VDB; XIRR; XNPV; YIELD; YIELDDISC; YIELDMAT

Math and Trigonometry Functions

Are used to perform basic math and trigonometry operations such as adding, multiplying, dividing, rounding, etc.

ABS; ACOS; ACOSH; ACOT; ACOTH; ARABIC; ASIN; ASINH; ATAN; ATAN2; ATANH; BASE; CEILING; CEILING.MATH; CEILING.PRECISE; COMBIN; COMBINA; COS; COSH; COT; COTH; CSC; CSCH; DECIMAL; DEGREES; EVEN; EXP; FACT; FACTDOUBLE; FLOOR; FLOOR.PRECISE; FLOOR.MATH; GCD; INT; ISO.CEILING; LCM; LN; LOG; LOG10; MDETERM; MINVERSE; MMULT; MOD; MROUND; MULTINOMIAL; ODD; PI; POWER; PRODUCT; QUOTIENT; RADIANS; RAND; RANDBETWEEN; ROMAN; ROUND; ROUNDDOWN; ROUNDUP; SEC; SECH; SERIESSUM; SIGN; SIN; SINH; SQRT; SQRTPI; SUBTOTAL; SUM; SUMIF; SUMIFS; SUMPRODUCT; SUMSQ; SUMX2MY2; SUMX2PY2; SUMXMY2; TAN; TANH; TRUNC

Lookup and Reference Functions | Are used to easily find the information from the data list. | ADDRESS; CHOOSE; COLUMN; COLUMNS; HLOOKUP; INDEX; INDIRECT; LOOKUP; MATCH; OFFSET; ROW; ROWS; TRANSPOSE; VLOOKUP
Information Functions | Are used to give you the information about the data in the selected cell or a range of cells. | ERROR.TYPE; ISBLANK; ISERR; ISERROR; ISEVEN; ISLOGICAL; ISNA; ISNONTEXT; ISNUMBER; ISODD; ISREF; ISTEXT; N; NA; TYPE
Logical Functions | Are used only to give you a TRUE or FALSE answer. | AND; FALSE; IF; IFERROR; IFNA; NOT; OR; TRUE; XOR