Powered by

AVS Document Editor
This page is available in EnglishFrançaisDeutschItalianoEspañol
AVS Document Editor
Download
AVS Document Editor
Current Version:  4.2.3.302
Release Date:  12/27/2016
File Size:
125.17 MB

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.

Basic Calculations

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 Insert Function icon 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 Function icon 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
Download AVS Document Editor Current Version:  4.2.3.302File Size: 125.17 MB

Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.

AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.