Close Help Center ONLYOFFICE Docs Spreadsheet Editor User guides ONLYOFFICE Workspace ONLYOFFICE Groups ONLYOFFICE Docs Mail Server Talk Module ONLYOFFICE Groups Documents Module People Module Commmunity Module CRM Module Projects Module Mail Module Calendar Module ONLYOFFICE Docs All Editors Document Editor Program interface Introducing the Document Editor user interface File tab Home tab Insert tab Draw tab Layout tab References tab Forms tab Collaboration tab Protection tab View tab Plugins tab Basic operations Create a new document or open an existing one Copy/paste text passages, undo/redo your actions Change color scheme Page formatting Set page parameters Show/hide nonprinting characters Insert section breaks Insert headers and footers Insert date and time Insert page numbers Insert line numbers Insert footnotes Insert endnotes Convert endnotes and footnotes Add bookmarks Add watermark Add hyphenation Paragraph formatting Align your text in a paragraph Set up paragraph outline level Select background color for a paragraph Change paragraph indents Set paragraph line spacing Insert page breaks Add borders Set tab stops Create lists Create hanging indents Text formatting Apply formatting presets Set font type, size, and color Apply font decoration styles Copy/clear text formatting Add hyperlinks Insert cross-references Insert a drop cap Operations on objects Insert tables Use formulas in tables Insert images Insert autoshapes Insert charts Insert text objects Insert SmartArt objects Draw freehand on a document Add caption Insert symbols Align and arrange objects on a page Change text wrapping Insert content controls Create a table of contents Add and format a table of figures Insert videos Fillable forms Create fillable forms Mail Merge Use Mail Merge Math equations Insert equations Collaboration Sharing files and folders Co-editing documents in real time Communicating in real time Commenting documents Tracking changes Comparing and combining documents Version history Plugins Plugin manager Edit an image Create and insert diagrams Edit HTML Correct typography Count words Include a video Insert highlighted code Insert references Translate text Extract text from an image Read the text out loud Type via voice Replace a word by a synonym Upload a document to Wordpress Communicate while editing Make Audio and Video Calls Host and schedule Zoom meetings Use AI to write text Insert definitions Add pictures Tools and settings View document information Save, download, print your document Advanced settings of Document Editor View settings and navigation tools ONLYOFFICE Document Viewer Search and replace function Spell-checking AutoCorrect features Protecting documents with a password Helpful hints About Document Editor Supported formats of electronic documents Keyboard shortcuts Spreadsheet Editor Program interface Introducing the Spreadsheet Editor user interface File tab Home tab Insert tab Draw tab Layout tab Formula tab Data tab Pivot Table tab Collaboration tab Protection tab View tab Plugins tab Basic operations Create a new spreadsheet or open an existing one Cut/copy/paste data Undo/redo your actions Add external links to cells Operations with sheets Manage sheets Insert headers and footers Insert breaks Cell text formatting Set font type, size, style, and colors Add hyperlinks Clear text, format in a cell Editing cell properties Add borders Align data in cells Merge cells Change number format Editing rows/columns Add cells Insert or delete cells, rows, and columns Freeze rows and columns Split cells Sort and filter data Use formatted tables Create and edit pivot tables Create slicers for tables Group data Remove duplicates Conditional formatting Data validation Work with functions Insert functions Insert array formulas Use named ranges Watch window Goal Seek Calculate percentages Insert time Switch between languages in a table Operations on objects Insert images Insert charts Insert sparklines Insert and format autoshapes Insert text objects Wrap text Insert SmartArt objects Draw freehand on a spreadsheet Insert symbols and characters Manipulate objects Math equations Insert equations Collaboration Sharing files and folders Co-editing spreadsheets in real time Managing sheet view presets Communicating in real time Commenting spreadsheets Version history Protecting a spreadsheet Protecting a spreadsheet Protecting ranges Protecting your spreadsheets with a password Protecting a sheet Protecting a workbook Plugins Plugin manager Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Communicate while editing Host and schedule Zoom meetings Use AI to write text Add pictures Tools and settings View file information Save/print/download your spreadsheet Scale a worksheet Advanced settings of Spreadsheet Editor View settings and navigation tools Search and replace functions Spell-checking AutoCorrect features Get data from TXT/CSV file Helpful hints About Spreadsheet Editor Supported formats of spreadsheets Keyboard shortcuts Presentation Editor Program interface Introducing the Presentation Editor user interface File tab Home tab Insert tab Draw tab Transitions tab Animation tab Collaboration tab View tab Plugins tab Basic operations Create a new presentation or open an existing one Copy/paste data, undo/redo your actions Working with slides Manage slides Set slide parameters Apply transitions Insert headers and footers, notes and handouts Preview your presentation Text formatting Insert and format your text Add hyperlinks Create lists Copy/clear formatting Operations on objects Insert and format autoshapes Insert and adjust images Insert and edit charts Insert and format tables Insert SmartArt objects Draw freehand on a slide Adding animations Creating a motion path animation Insert symbols and characters Fill objects and select colors Manipulate objects on a slide Align and arrange objects on a slide Math equations Insert equations Collaboration Sharing files and folders Co-editing presentations in real time Communicating in real time Commenting presentations Version history Plugins Plugin manager Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Communicate while editing Host and schedule Zoom meetings Use AI to write text Add pictures Tools and settings View presentation information Save/print/download your presentation Advanced settings of Presentation Editor View settings and navigation tools Search and Replace Function Spell-checking AutoCorrect features Protecting presentations with a password Enable support for video playback in ONLYOFFICE Desktop Editors Helpful hints About Presentation Editor Supported formats of electronic presentations Keyboard shortcuts PDF Editor Program interface Introducing the PDF Editor user interface File tab Home tab Comment tab View tab Plugins tab Basic operations Open an existing PDF or create a new document Filling out a form Collaboration Sharing files and folders Communicating in real time Commenting PDFs Draw freehand on a PDF Plugins Edit HTML Count words Find a synonym Translate text Read the text out loud Communicate while editing Tools and settings View PDF information Save/print/download your PDF Advanced settings of PDF Editor View settings and navigation tools Search function Helpful hints About PDF Editor Keyboard shortcuts ONLYOFFICE Mobile Apps ONLYOFFICE Documents for iOS ONLYOFFICE Documents for Android ONLYOFFICE Projects for iOS ONLYOFFICE Web Editors Glossary Video FAQ General Technology Pricing Workspace Enterprise Edition Docs Enterprise Edition Docs Developer Edition ONLYOFFICE Groups Connectors Trial period Insert functions data processing Change number format Insert and edit charts Insert functions Use named ranges Sort and filter data Create and edit pivot tables Group data Conditional Formatting More articles Use formatted tables Create slicers for tables Remove duplicates Data validation Insert sparklines Insert array formulas Change number format Insert formulas Sort and filter data Change number format Sort and filter data Insert formulas Change number format Sort and filter data Insert formulas Change number format Sort and filter data Insert formulas Creating a chart from start to finish using functions Insert functions Use named ranges Use formulas in tables Insert formulas Insert formulas Insert formulas Insert formulas Insert array formulas using named ranges Use named ranges Insert functions math and trigonometry functions ABS function ACOS function ACOSH function ACOT function ACOTH function AGGREGATE function ARABIC function ASIN function More articles ASINH function ATAN function ATAN2 function ATANH function BASE function CEILING function CEILING.MATH function CEILING.PRECISE function COMBIN function COMBINA function COS function COSH function COT function COTH function CSC function CSCH function DECIMAL function DEGREES function ECMA.CEILING function EVEN function EXP function FACT function FACTDOUBLE function FLOOR function FLOOR.PRECISE function FLOOR.MATH function GCD function INT function ISO.CEILING function LCM function LN function LOG function LOG10 function MDЕTERM function MINVERSE function MMULT function MOD function MROUND function MULTINOMIAL function MUNIT function ODD function PI function POWER function PRODUCT function QUOTIENT function RADIANS function RAND function RANDBETWEEN function RANDARRAY function ROMAN function ROUND function ROUNDDOWN function ROUNDUP function SEC function SECH function SERIESSUM function SIGN function SIN function SINH function SQRT function SQRTPI function SUBTOTAL function SUM function SUMIF function SUMPRODUCT function SUMSQ function SUMX2MY2 function SUMX2PY2 function SUMXMY2 function TAN function TANH function TRUNC function SUMIFS function information functions CELL function ERROR.TYPE function ISBLANK function ISERR function ISERROR function ISEVEN function ISFORMULA function ISLOGICAL function More articles ISNA function ISNONTEXT function ISNUMBER function ISODD function ISREF function ISTEXT function N function NA function SHEET function SHEETS function TYPE function logical functions AND function FALSE function IF function IFERROR function IFNA function IFS function NOT function OR function More articles SWITCH function How to switch between two languages in a table TRUE function XOR function Using the IF and AND functions lookup and reference functions ADDRESS function CHOOSE function COLUMN function COLUMNS function HLOOKUP function HYPERLINK function INDEX function INDIRECT function More articles FORMULATEXT function LOOKUP function MATCH function OFFSET function ROW function ROWS function TRANSPOSE function VLOOKUP function XLOOKUP function HSTACK function TOCOL function TOROW function VSTACK function WRAPCOLS function WRAPROWS function CHOOSEROWS function CHOOSECOLS function DROP function TAKE function statistical functions AVEDEV function AVERAGE function AVERAGEA function AVERAGEIF function AVERAGEIFS function BETADIST function BETA.DIST function BETA.INV function More articles BETAINV function BINOMDIST function BINOM.DIST function BINOM.DIST.RANGE function BINOM.INV function CHIDIST function CHIINV function CHISQ.DIST function CHISQ.DIST.RT function CHISQ.INV function CHISQ.INV.RT function CHITEST function CHISQ.TEST function CONFIDENCE function CONFIDENCE.NORM function CONFIDENCE.T function CORREL function COUNT function COUNTA function COUNTBLANK function COUNTIF function COUNTIFS function COVAR function COVARIANCE.P function COVARIANCE.S function CRITBINOM function DEVSQ function EXPON.DIST function EXPONDIST function F.DIST function FDIST function F.DIST.RT function F.INV function FINV function F.INV.RT function FISHER function FISHERINV function FORECAST function FORECAST.ETS function FORECAST.ETS.CONFINT function FORECAST.ETS.SEASONALITY function FORECAST.ETS.STAT function FORECAST.LINEAR function FREQUENCY function FTEST function F.TEST function GAMMA function GAMMA.DIST function GAMMADIST function GAMMA.INV function GAMMAINV function GAMMALN function GAMMALN.PRECISE function GAUSS function GEOMEAN function GROWTH function HARMEAN function HYPGEOMDIST function HYPGEOM.DIST function INTERCEPT function KURT function LARGE function LINEST function LOGEST function LOGINV function LOGNORM.DIST function LOGNORM.INV function LOGNORMDIST function MAX function MAXA function MAXIFS function MEDIAN function MIN function MINA function MINIFS function MODE function MODE.MULT function MODE.SNGL function NEGBINOMDIST function NEGBINOM.DIST function NORMDIST function NORM.DIST function NORMINV function NORM.INV function NORMSDIST function NORM.S.DIST function NORMSINV function NORM.S.INV function PEARSON function PERCENTILE function PERCENTILE.EXC function PERCENTILE.INC function PERCENTRANK function PERCENTRANK.EXC function PERCENTRANK.INC function PERMUT function PERMUTATIONA function PHI function POISSON function POISSON.DIST function PROB function QUARTILE function QUARTILE.EXC function QUARTILE.INC function RANK function RANK.AVG function RANK.EQ function RSQ function SKEW function SKEW.P function SLOPE function SMALL function STANDARDIZE function STDEV function STDEV.S function STDEVA function STDEVP function STDEV.P function STDEVPA function STEYX function TDIST function T.DIST function T.DIST.2T function T.DIST.RT function T.INV function T.INV.2T function TINV function TRIMMEAN function TREND function TTEST function T.TEST function UNIQUE function VAR function VARA function VARP function VAR.P function VAR.S function VARPA function WEIBULL function WEIBULL.DIST function ZTEST function Z.TEST function Using the AVERAGE function text and data functions ASC function CHAR function CLEAN function CODE function CONCATENATE function CONCAT function DOLLAR function EXACT function More articles FIND/FINDB functions FIXED function LEFT/LEFTB functions LEN/LENB function LOWER function MID/MIDB functions NUMBERVALUE function PROPER function REPLACE/REPLACEB functions REPT function RIGHT/RIGHTB functions SEARCH/SEARCHB functions SUBSTITUTE function T function TEXT function TEXTJOIN function UNICHAR function UNICODE function UPPER function VALUE function TEXTAFTER function TEXTBEFORE function TEXTSPLIT function financial functions ACCRINT function ACCRINTM function AMORDEGRC function AMORLINC function COUPDAYBS function COUPDAYS function COUPDAYSNC function COUPNCD function More articles COUPNUM function COUPPCD function CUMIPMT function CUMPRINC function DB function DDB function DISC function DOLLARDE function DOLLARFR function DURATION function EFFECT function FV function FVSCHEDULE function INTRATE function IPMT function IRR function ISPMT function MDURATION function MIRR function NOMINAL function NPER function NPV function ODDFPRICE function ODDFYIELD function ODDLPRICE function ODDLYIELD function PDURATION function PMT function PPMT function PRICE function PRICEDISC function PRICEMAT function PV function RATE function RECEIVED function RRI function SLN function SYD function TBILLEQ function TBILLPRICE function TBILLYIELD function VDB function XIRR function XNPV function YIELD function YIELDDISC function YIELDMAT function engineering functions BESSELI function BESSELJ function BESSELK function BESSELY function BIN2DEC function BIN2HEX function BIN2OCT function BITAND function More articles BITLSHIFT function BITOR function BITRSHIFT function BITXOR function COMPLEX function CONVERT function DEC2BIN function DEC2HEX function DEC2OCT function DELTA function ERF function ERF.PRECISE function ERFС function ERFC.PRECISE function GESTEP function HEX2BIN function HEX2DEC function HEX2OCT function IMABS function IMAGINARY function IMARGUMENT function IMCONJUGATE function IMCOS function IMCOSH function IMCOT function IMCSC function IMCSCH function IMDIV function IMEXP function IMLN function IMLOG10 function IMLOG2 function IMPOWER function IMPRODUCT function IMREAL function IMSEC function IMSECH function IMSIN function IMSINH function IMSQRT function IMSUB function IMSUM function IMTAN function OCT2BIN function OCT2DEC function OCT2HEX function database functions DAVERAGE function DCOUNT function DCOUNTA function DGET function DMAX function DMIN function DPRODUCT function DSTDEV function More articles DSTDEVP function DSUM function DVAR function DVARP function The ability to perform basic calculations is the principal reason for using the Spreadsheet Editor. Some of them are performed automatically when you select a cell range in your spreadsheet: Average is used to analyze the selected cell range and find the average value. Count is used to count the number of the selected cells with values ignoring the empty cells. Min is used to analyze the range of data and find the smallest number. Max is used to analyze the range of data and find the largest number. Sum is used to add all the numbers in the selected range ignoring the empty cells or those contaning text. The results of these calculations are displayed in the right lower corner on the status bar. You can manage the status bar by right-clicking on it and choosing only those functions to display that you need. To perform any other calculations, you can insert the required formula manually using the common mathematical operators or insert a predefined formula - Function. The abilities to work with Functions are accessible from both the Home and Formula tab or by pressing Shift+F3 key combination. On the Home tab, you can use the Insert function button to add one of the most commonly used functions (SUM, AVERAGE, MIN, MAX, COUNT) or open the Insert Function window that contains all the available functions classified by category. Use the search box to find the exact function by its name. On the Formula tab you can use the following buttons: Function - to open the Insert Function window that contains all the available functions classified by category. Autosum - to quickly access the SUM, MIN, MAX, COUNT functions. When you select a functions from this group, it automatically performs calculations for all cells in the column above the selected cell so that you don't need to enter arguments. Recently used - to quickly access 10 recently used functions. Financial, Logical, Text and data, Date and time, Lookup and references, Math and trigonometry - to quickly access functions that belongs to the corresponding categories. More functions - to access the functions from the following groups: Database, Engineering, Information and Statistical. Named ranges - to open the Name Manager, or define a new name, or paste a name as a function argument. For more details, you can refer to this page. Trace Precedents - to show arrows that indicate which cells affect the value of the selected cell. Trace Dependents - to show arrows that indicate which cells are affected by the value of the selected cell. Remove Arrows - to remove the arrows used for precedents and dependents. Click the arrow next to the Remove Arrows option to choose whether to remove all arrows, precedent arrows, or dependent arrows. Show Formulas - to show the formulas used in the cells instead of the final results of the formulas. Watch Window - to display changes in the cells that are not currently in the visible area of the worksheet. To learn more about the Watch Window, please read the following article. Calculation - to force the program to recalculate functions. How to apply functions To insert a function, Select a cell where you wish to insert a function. Proceed in one of the following ways: switch to the Formula tab and use the buttons available on the top toolbar to access a function from a specific group, then click the necessary function to open the Function Arguments wizard. You can also use the Additional option from the menu or click the Function button on the top toolbar to open the Insert Function window. switch to the Home tab, click the Insert function icon, select one of the commonly used functions (SUM, AVERAGE, MIN, MAX, COUNT) or click the Additional option to open the Insert Function window. right-click within the selected cell and select the Insert Function option from the contextual menu. click the icon before the formula bar. In the opened Insert Function window, enter its name in the search box or select the necessary function group, then choose the required function from the list and click OK. Once you click the necessary function, the Function Arguments window will open: In the opened Function Arguments window, enter the necessary values of each argument. You can enter the function arguments either manually or by clicking the icon and selecting a cell or cell range to be included as an argument. 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. The function result will be displayed below. When all the agruments are specified, click the OK button in the Function Arguments window. To enter a function manually using the keyboard, Select a cell. Enter the equal sign (=). Each formula must begin with the equal sign (=). Enter the function name. Once you type the initial letters, the Formula Autocomplete list will be displayed. As you type, the items (formulas and names) that match the entered characters are displayed in it. If you hover the mouse pointer over a formula, a tooltip with the formula description will be displayed. You can select the necessary formula from the list and insert it by clicking it or pressing the Tab key. Enter the function arguments either manually or by dragging to select a cell range to be included as an argument. If the function requires several arguments, they must be separated by commas. Arguments must be enclosed into parentheses. The opening parenthesis '(' is added automatically if you select a function from the list. When you enter arguments, a tooltip that contains the formula syntax is also displayed. When all the agruments are specified, enter the closing parenthesis ')' and press Enter. If you enter new data or change the values used as arguments, recalculation of functions is performed automatically by default. You can force the program to recalculate functions by using the Calculation button on the Formula tab. Click the Calculation button to recalculate the entire workbook, or click the arrow below the button and choose the necessary option from the menu: Calculate workbook or Calculate current sheet. You can also use the following key combinations: F9 to recalculate the workbook, Shift +F9 to recalculate the current worksheet. Here is the list of the available functions grouped by categories: Function Category Description Functions Text and Data Functions Used to correctly display the text data in the spreadsheet. ARRAYTOTEXT; ASC; 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; TEXTJOIN; TRIM; UNICHAR; UNICODE; UPPER; VALUE; TEXTBEFORE; TEXTAFTER; TEXTSPLIT Statistical Functions Used to analyze data: finding the average value, the largest or smallest values in a cell range. AVEDEV; AVERAGE; AVERAGEA; AVERAGEIF; AVERAGEIFS; BETADIST; BETA.DIST; BETA.INV; BETAINV; BINOMDIST; BINOM.DIST; BINOM.DIST.RANGE; BINOM.INV; CHIDIST; CHIINV; CHISQ.DIST; CHISQ.DIST.RT; CHISQ.INV; CHISQ.INV.RT; CHITEST; CHISQ.TEST; CONFIDENCE; CONFIDENCE.NORM; CONFIDENCE.T; CORREL; COUNT; COUNTA; COUNBLANK; COUNTIF; COUNTIFS; COVAR; COVARIANCE.P; COVARIANCE.S; CRITBINOM; DEVSQ; EXPON.DIST; EXPONDIST; F.DIST; FDIST; F.DIST.RT; F.INV; FINV; F.INV.RT; FISHER; FISHERINV; FORECAST; FORECAST.ETS; FORECAST.ETS.CONFINT; FORECAST.ETS.SEASONALITY; FORECAST.ETS.STAT; FORECAST.LINEAR; FREQUENCY; FTEST; F.TEST; GAMMA; GAMMA.DIST; GAMMADIST; GAMMA.INV; GAMMAINV; GAMMALN; GAMMALN.PRECISE; GAUSS; GEOMEAN; GROWTH; HARMEAN; HYPGEOMDIST; HYPGEOM.DIST; INTERCEPT; KURT; LARGE; LINEST; LOGEST, LOGINV; LOGNORM.DIST; LOGNORM.INV; LOGNORMDIST; MAX; MAXA; MAXIFS; MEDIAN; MIN; MINA; MINIFS; MODE; MODE.MULT; MODE.SNGL; NEGBINOMDIST; NEGBINOM.DIST; NORMDIST; NORM.DIST; NORMINV; NORM.INV; NORMSDIST; NORM.S.DIST; NORMSINV; NORM.S.INV; PEARSON; PERCENTILE; PERCENTILE.EXC; PERCENTILE.INC; PERCENTRANK; PERCENTRANK.EXC; PERCENTRANK.INC; PERMUT; PERMUTATIONA; PHI; POISSON; POISSON.DIST; PROB; QUARTILE; QUARTILE.EXC; QUARTILE.INC; RANK; RANK.AVG; RANK.EQ; RSQ; SKEW; SKEW.P; SLOPE; SMALL; STANDARDIZE; STDEV; STDEV.S; STDEVA; STDEVP; STDEV.P; STDEVPA; STEYX; TDIST; T.DIST; T.DIST.2T; T.DIST.RT; T.INV; T.INV.2T; TINV; TREND, TRIMMEAN; TTEST; T.TEST; VAR; VARA; VARP; VAR.P; VAR.S; VARPA; WEIBULL; WEIBULL.DIST; ZTEST; Z.TEST Math and Trigonometry Functions Used to perform basic math and trigonometry operations such as adding, multiplying, dividing, rounding, etc. ABS; ACOS; ACOSH; ACOT; ACOTH; AGGREGATE; ARABIC; ASIN; ASINH; ATAN; ATAN2; ATANH; BASE; CEILING; CEILING.MATH; CEILING.PRECISE; COMBIN; COMBINA; COS; COSH; COT; COTH; CSC; CSCH; DECIMAL; DEGREES; ECMA.CEILING; EVEN; EXP; FACT; FACTDOUBLE; FLOOR; FLOOR.PRECISE; FLOOR.MATH; GCD; INT; ISO.CEILING; LCM; LN; LOG; LOG10; MDETERM; MINVERSE; MMULT; MOD; MROUND; MULTINOMIAL; MUNIT; ODD; PI; POWER; PRODUCT; QUOTIENT; RADIANS; RAND; RANDARRAY; RANDBETWEEN; ROMAN; ROUND; ROUNDDOWN; ROUNDUP; SEC; SECH; SERIESSUM; SEQUENCE; SIGN; SIN; SINH; SQRT; SQRTPI; SUBTOTAL; SUM; SUMIF; SUMIFS; SUMPRODUCT; SUMSQ; SUMX2MY2; SUMX2PY2; SUMXMY2; TAN; TANH; TRUNC Date and Time Functions Used to correctly display the date and time in the spreadsheet. DATE; DATEDIF; DATEVALUE; DAY; DAYS; DAYS360; EDATE; EOMONTH; HOUR; ISOWEEKNUM; MINUTE; MONTH; NETWORKDAYS; NETWORKDAYS.INTL; NOW; SECOND; TIME; TIMEVALUE; TODAY; WEEKDAY; WEEKNUM; WORKDAY; WORKDAY.INTL; YEAR; YEARFRAC Engineering Functions Used to perform some engineering calculations: converting between different bases number systems, finding complex numbers etc. BESSELI; BESSELJ; BESSELK; BESSELY; BIN2DEC; BIN2HEX; BIN2OCT; BITAND; BITLSHIFT; BITOR; BITRSHIFT; BITXOR; COMPLEX; CONVERT; DEC2BIN; DEC2HEX; DEC2OCT; DELTA; ERF; ERF.PRECISE; ERFC; ERFC.PRECISE; 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 Database Functions Used to perform calculations for the values in a certain field of the database that meet the specified criteria. DAVERAGE; DCOUNT; DCOUNTA; DGET; DMAX; DMIN; DPRODUCT; DSTDEV; DSTDEVP; DSUM; DVAR; DVARP Financial Functions 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; PDURATION; PMT; PPMT; PRICE; PRICEDISC; PRICEMAT; PV; RATE; RECEIVED; RRI; SLN; SYD; TBILLEQ; TBILLPRICE; TBILLYIELD; VDB; XIRR; XNPV; YIELD; YIELDDISC; YIELDMAT Lookup and Reference Functions Used to easily find information from the data list. ADDRESS; CHOOSE; CHOOSECOLS; CHOOSEROWS; COLUMN; COLUMNS; DROP; EXPAND; FILTER; FORMULATEXT; HLOOKUP; HSTACK; HYPERLINK; INDEX; INDIRECT; LOOKUP; MATCH; OFFSET; ROW; ROWS; SORT; SORTBY; TAKE; TOCOL; TOROW; TRANSPOSE; UNIQUE; VLOOKUP; VSTACK; WRAPCOLS; WRAPROWS; XLOOKUP; XMATCH Information Functions Used to provide information about the data in the selected cell or cell range. CELL; ERROR.TYPE; ISBLANK; ISERR; ISERROR; ISEVEN; ISFORMULA; ISLOGICAL; ISNA; ISNONTEXT; ISNUMBER; ISODD; ISREF; ISTEXT; N; NA; SHEET; SHEETS; TYPE Logical Functions Used to check if a condition is true or false. AND; FALSE; IF; IFERROR; IFNA; IFS; NOT; OR; SWITCH; TRUE; XOR Return to previous page Try now for free Try and make your decision No need to install anythingto see all the features in action