SpreadsheetGear Features
The SpreadsheetGear family of products is made up of powerful and flexible Microsoft Excel compatible spreadsheet components and includes SpreadsheetGear 2023 for .NET Framework, SpreadsheetGear Engine for .NET and SpreadsheetGear for Windows.
SpreadsheetGear enables ASP.NET, ASP.NET Core, Windows Forms, WPF, iOS, Android, Linux, macOS and UWP developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.
Which SpreadsheetGear product is right for you?
SpreadsheetGear 2023 for .NET Framework comes with assemblies built for .NET Framework 3.5 and .NET 4.6.2. SpreadsheetGear Engine for .NET requires a platform which supports .NET 6 or .NET Standard 2.0 or later. SpreadsheetGear for Windows requires .NET 6 for Windows or later. Although the feature set across products are very similar, there are some differences...
Feature Finder
General Features
 Royalty free deployment to 32bit and 64bit Windows 8.1, Windows 10, Windows Server 2012 (including R2), Windows Server 2016, Windows Server 2019 and Windows Server 2022.
 Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel 972003 (xls) and Excel 20072019 Open XML (xlsx and xlsm) workbooks without Excel.Related Samples:
 ASP.NET Razor Pages Samples
 Scalable and reliable Excel Reporting.Related Samples:
 ASP.NET Razor Pages Samples
 Excel Reporting
 Simple Excel Report
 Excel Report with Formulas and Formatting
 Excel Report with Formatted Chart
 Excel Report with Chart (From Template Workbook)
 Excel Report with Chart Linked to Defined Name
 Worksheet with Chart to Multiple Worksheets with Charts
 Excel Report with Picture
 DataTable to Excel Workbook
 DataTable to Excel Workbook with Chart
 DataTable to Excel Workbook with Formats and Formulas
 DataSet to Excel Workbook with Formats and Formulas
 SQL DataTable to Workbook
 SQL DataTable to Template Workbook
 Excel Workbook Consolidation
 Group, Outline and Summarize to Excel
 Excel Reporting
 ASP.NET Razor Pages Samples
 Powerful Windows Forms and WPF spreadsheet controls.Related Samples:
 Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel in many cases).Related Samples:
 ASP.NET Razor Pages Samples
 Easily create images from Excel charts and ranges.Related Samples:
 ASP.NET Razor Pages Samples
 Comprehensive Excel compatible charting.Related Samples:
 SpreadsheetGear API Samples
 ASP.NET Razor Pages Samples
 Versatile autofilters with top or bottom n items or percent, above or below average, font color, cell color, conditional format icon, custom criteria, sorting, SUBTOTAL and more. Related Samples:
 SpreadsheetGear API Samples
 Read and write password protected xls, xlsx and xlsm workbooks, including new Agile Encryption used by Excel 2013 and later.Related Samples:
 SpreadsheetGear API Samples
 Read and write CSV and tab separated text files.Related Samples:
 ASP.NET Razor Pages Samples
 Support for cell comments, pictures, text boxes, check boxes, dropdowns, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.Related Samples:
 SpreadsheetGear API Samples
 Drag Fill / Auto Fill including support for numbers, dates, times, month names, day names and certain text patterns.
 Fill Data Series support including automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends.Related Samples:
 SpreadsheetGear API Samples
 Fast single variable and single target goal seeking.Related Samples:
 SpreadsheetGear API Samples
 Data validation including operators, alert messages, alert styles, custom formulas and dropdown lists.Related Samples:
 SpreadsheetGear API Samples
 Conditional formats with support for simple comparison operators and custom formulas.Related Samples:
 SpreadsheetGear API Samples
 Range Samples
 SpreadsheetGear API Samples
 Copy and insert DataTables into preformatted ranges with complete formula, border and format fixups.Related Samples:
 ASP.NET Razor Pages Samples
 Easily convert entire workbooks or specific ranges to a DataSet or DataTable.
 Copy, transpose and consolidate across cells, worksheets, workbooks and workbook sets.
 Insert, delete and clear rows, columns and cells.
 Stable sort with an unlimited number of keys and the ability to sort text as numbers.Related Samples:
 SpreadsheetGear API Samples
 Grouping and outlining of rows and columns.Related Samples:
 ASP.NET Razor Pages Samples
 Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
 Copy, insert and move entire worksheets.Related Samples:
 SpreadsheetGear API Samples
 ASP.NET Razor Pages Samples
 Reads and writes VBA Macros (preservation onlydoes not include execution of Macros).
 A wide variety of C# samples including live samples for ASP.NET Core Razor Pages and Windows Forms.
Calculation Engine
 Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel in many cases).Related Samples:
 ASP.NET Razor Pages Samples
 Multithreaded calculations efficiently utilize today's multicore CPUs.
 Interruptible background calculation enables responsive applications.
 449 Excel compatible financial, date, time, text, lookup, math, trigonometry, statistical, engineering, database, information, logical and web functions (see list here).Related Samples:
 ASP.NET Razor Pages Samples
 All types, operators, defined names, data tables and arrays.Related Samples:
 Support for 64K worksheets and unlimited workbooks in formulas.
 Worksheet specific defined names and global defined names.Related Samples:
 SpreadsheetGear API Samples
 BuiltIn Document Properties and Custom Document Properties.Related Samples:
 SpreadsheetGear API Samples
 Custom functions, minimal recalc, iteration, precision as displayed and more.Related Samples:
 ASP.NET Razor Pages Samples
 Copy formulas between cells, worksheets, workbooks and workbook sets with full support for reference fixups.
 Insert and delete worksheets, rows, columns and cells with full support for reference fixups.
 Cut, copy and paste with full support for smart reference fixups across multiple worksheets and workbooks.
 Special care was taken with numerical stability.
Workbook Features
 Read and write workbooks to disk, memory streams and byte arrays.Related Samples:
 Read and write password protected xls, xlsx and xlsm workbooks, including new Agile Encryption used by Excel 2013 and later.Related Samples:
 SpreadsheetGear API Samples
 Workbook and worksheet scoped named ranges.Related Samples:
 SpreadsheetGear API Samples
 BuiltIn Document Properties and Custom Document Properties.Related Samples:
 SpreadsheetGear API Samples
 Options to show and hide worksheet tabs and scrollbars.Related Samples:
 SpreadsheetGear API Samples
 Helper methods to convert Excel Serial Dates and Times to .NET DateTime objects and back.Related Samples:
 SpreadsheetGear API Samples
Worksheet Features
 Top or bottom n items.
 Top or bottom n percent.
 Above or below average.
 Last day, month, quarter, week or year.
 This day, month, quarter, week or year.
 Next day, month, quarter, week or year.
 Specific day, month, year, hour, minute or second.
 Year to date.
 Filter by font color, interior color or conditional format icon.
 Custom criteria such as ">50".
 Filter by specific list of values.
 Support for the SUBTOTAL function which works in conjunction with autofilters to return various statistics for filtered items including average, count, max, min, product, standard deviation, sum and variance.
 Autofilter support in many commands including cell formatting, copy paste, fill, delete and more.
 Drag Fill / AutoFill, including support for numbers, dates, times, month names, day names and certain text patterns.
 Fill Data Series support including automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends.Related Samples:
 SpreadsheetGear API Samples
 GoalSeek  Fast single variable and single target goal seeking.Related Samples:
 SpreadsheetGear API Samples
 Cell Data Validation  including operators, alert messages, alert styles, custom formulas and dropdown lists.Related Samples:
 SpreadsheetGear API Samples
 Conditional Formatting
 Simple comparison operatorsRelated Samples:
 SpreadsheetGear API Samples
 Custom formulasRelated Samples:
 SpreadsheetGear API Samples
 Icon SetsRelated Samples:
 SpreadsheetGear API Samples
 Data BarsRelated Samples:
 SpreadsheetGear API Samples
 Color ScalesRelated Samples:
 SpreadsheetGear API Samples
 Highlight CellsRelated Samples:
 SpreadsheetGear API Samples
 Top n / Bottom n RulesRelated Samples:
 SpreadsheetGear API Samples
 Advanced Rules
 Overlapping Rules
 Simple comparison operators
 ADO.NET DataSet and DataTable ConversionRelated Samples:
 Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
 Insert, delete and clear rows, columns and cells.
 Enable or disable worksheet protection, worksheet passwords and cell locking.Related Samples:
 SpreadsheetGear API Samples
 Autoshapes, text boxes and pictures including JPEG, PNG, GIF, BMP, WMF and EMF.Related Samples:
 ASP.NET Razor Pages Samples
Printing Features
 Print workbooks, worksheets, ranges and charts in any combination.
 Horizontal and vertical page breaks.Related Samples:
 SpreadsheetGear API Samples
 Page Setup Options
 Print area, title rows / title columns and orientation.Related Samples:
 SpreadsheetGear API Samples
 Margins, page order, page zoom and fit to pages.Related Samples:
 SpreadsheetGear API Samples
 Custom headers and footers included embedded pictures.Related Samples:
 SpreadsheetGear API Samples
 Print area, title rows / title columns and orientation.
 Print preview.
 Print to XPS files.
Charting Features
 The most comprehensive Excel compatible charting support available in a Microsoft .NET Framework component.Related Samples:
 SpreadsheetGear API Samples
 ASP.NET Razor Pages Samples
 GDI+ and XAML imaging classes provide the ability to generate an image (such as GIF or PNG) with one line of code.
 Chart rendering supports the most common charting features:
 Chart types include area, bar, column, line, pie, stock, XY scatter, radar and bubble charts.
 Chart type options include multiple chart groups (combination charts), stacked and 100% stacked values, bar gap and overlap, line markers, drop lines, highlow lines, trendlines, series line smoothing, openclose bars, error bars, exploded pies, and data point labels.
 Axes options include axes titles, primary and secondary axes sets, auto and manual scaling, logarithmic and date scales, major and minor gridlines and tick marks, reversed axes, tick label positions and rotated text.
 General chart options include chart titles, legends, theme colors, auto colors, gradients including Excel compatible preset gradients, solid and dashed line styles, number formats and fonts.
Formatting Features
 Number formats, including full support for getting and setting Excel compatible custom number formats as well as getting the formatted text of a cell as Excel would display it.Related Samples:
 SpreadsheetGear API Samples
 ASP.NET Razor Pages Samples
 Fonts, borders, cell interior color and gradient fills, Office theme colors with tinting and shading, RGB colors, Excel palette indexed colors and patterns.
 Horizontal alignment, vertical alignment, word wrap and rotated text.Related Samples:
 SpreadsheetGear API Samples
 Merged cells, hyperlinks and conditional formats.Related Samples:
 SpreadsheetGear API Samples
 Grouping and outlining of rows and columns.Related Samples:
 SpreadsheetGear API Samples
 ASP.NET Razor Pages Samples
 Automatic row heights and column widths.
 Copy formats without affecting formulas or values.
 Named cell style support.Related Samples:
 SpreadsheetGear API Samples
 Workbook
 Styles
 Workbook
 SpreadsheetGear API Samples
Spreadsheet Control Features
 SpreadsheetGear Explorer Sample Solutions for Windows provide source code which demonstrates commonly used features and APIs.Related Samples:
 Windows Forms and WPF WorkbookView spreadsheet controls provide viewing, navigation and editing support which is familiar to Excel users.
 Incell editing and optional FormulaBar control provide the ability to enter and edit cell values and formulas, including support for pointing at cell references in formulas across worksheets and workbooks.
 Smart data entry with optional data validation as well as automatic recognition and formatting of dates, times, percentages, currency, scientific notation and fractions will be familiar to Excel users.
 Conditional formatting enables font colors, font styles, background colors, borders as well as other graphical features such icon sets, data bars, color scales and more, which are based on simple comparison operators, complex formulas or more advanced rules.
 Grouping and outlining which allows users to easily expand and collapse the displayed level of detail.
 WorkbookDesigner provides an MDI Windows application which may be used from within Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, Visual Studio 2019 and Visual Studio 2022 at Design Time and by your applications at run time.
 WorkbookExplorer provides the ability to manipulate workbooks, worksheets and defined names as well as their properties.
 RangeExplorer provides extensive modeless formatting of the currently selected range with support for number formats, alignment, fonts, borders, colors, patterns, gradients, protection options, hyperlinks, conditional formats and data validation.
 ChartExplorer provides basic modeless modification and formatting of the selected chart with support for chart types and data sources, legend options, primary and secondary axes options and various series options.
 Modeless find and replace dialog with support for find, find all, replace and replace all.
 Support for an unlimited number of workbooks associated with each WorkbookView.
 DisplayReference and DisplayReferenceName properties allow complete control over what appears for each sheet tab, including the ability to make multiple workbooks appear as one workbook and the ability to specify dynamically changing ranges using worksheet functions such as OFFSET().
 Cut, copy, paste and paste special support including rich data and formatting interchange with Excel and full formula fixups.
 Frozen rows and columns, split panes, sheet tab colors, zoom, multilevel undo/redo, autofit rows and columns, goto, clear, printing, print preview, interruptible background calculation, real time workbook updates and more.
 CommandManager provides the ability to add custom undoable commands as well as the ability to override the behavior of common commands.
 Full integration with Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, Visual Studio 2019 and Visual Studio 2022 including the ability to use the WorkbookDesigner, WorkbookExplorer, RangeExplorer, ChartExplorer and ShapeExplorer at design time and at runtime.
Supported File Formats
 XLSX  Open XML Workbook
 XLSM  Open XML Macro Enabled Workbook
 XLS  Excel 972003 Workbook
 CSV  Comma Delimited Text
 TXT  Tab Delimited Text
Microsoft .NET Features
 Easy to use API which will be familiar to Excel VBA and COM developers while taking advantage of .NET's expressiveness.
 Supports 32 and 64 bit versions of the Microsoft .NET Framework NET 3.5 .NET 4.0, .NET 4.5.x, .NET 4.6.x, .NET 4.7.x, .NET 4.8, as well as .NET 6 and any platform that supports .NET Standard 2.0.
 Supports 32 and 64 bit versions of Windows 8.1, Windows 10, Windows Server 2012 (including R2), Windows Server 2016, Windows Server 2019 and Windows Server 2022.
 Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, Visual Studio 2019 and Visual Studio 2022 integration, including IntelliSense and Dynamic Help.
 The security of 100 percent safe managed code which does not require FullTrust.
 Hasslefree deployment with strongnamed assemblies as well as no license keys, registry entries or configuration issues.

No dependency on Microsoft Excel, which is not supported in a server environment.
Supported ExcelCompatible Functions
449 of Excel's financial, date, time, text, lookup, math, trigonometry, statistical, engineering, database, information, logical and web functions. Click here for a list of unsupported functions.
Database and List Management Functions  

DAVERAGE  Indicates the average of the values that meet the specified criteria. 
DCOUNT  Counts the number of cells containing numbers that meet the specified criteria. 
DCOUNTA  Counts nonblank cells containing numbers or text that meet the specified criteria. 
DGET  Returns a single value that meets the specified criteria. 
DMAX  Extracts the highest value that meets the specified criteria. 
DMIN  Extracts the lowest value that meets the specified criteria. 
DPRODUCT  Returns the product of the values that meet the specified criteria. 
DSTDEV  Estimates the standard deviation of a population, based on a sample of selected entries from the database. 
DSTDEVP  Returns the calculation of the standard deviation of a population, based on the sum of the whole population. 
DSUM  Returns the total of the values that meet the specified criteria. 
DVAR  Estimates the variance of a sample population based on the values that meet the specified criteria. 
DVARP  Returns the calculation of the true variance of an entire population based on the values that meet the specified criteria. 
Date and Time Functions  

DATE  Returns the serial number that represents a date. 
DATEDIF  2009 (V5) 
DATEVALUE  Converts date text to a DATEVALUE serial number. 
DAY  Returns the corresponding day of the month serial number or date text from 1 to 31. 
DAYS  2017 (V8) 
DAYS360  Returns the number of days between two set dates based on a 360day year. 
EDATE  2009 (V5) 
EOMONTH  2009 (V5) 
HOUR  Returns the hour as a serial number integer between 0 and 23. 
ISOWEEKNUM  2017 (V8) 
MINUTE  Returns the serial number that corresponds to the minute. 
MONTH  Returns the corresponding serial number of the month of a date between 1 and 12. 
NETWORKDAYS  2009 (V5) 
NETWORKDAYS.INTL  2012 (V7) 
NOW  Returns the current date and time in the form of a serial number. 
SECOND  Returns the seconds portion of a serial time value. 
TIME  Returns the decimal value of a given time. 
TIMEVALUE  Returns the decimal number for a given time. 
TODAY  Returns the current date as a serial number. 
WEEKDAY  Returns the corresponding day of the week as a serial number. 
WEEKNUM  2009 (V5) 
WORKDAY  2009 (V5) 
WORKDAY.INTL  2012 (V7) 
YEAR  Returns the corresponding year as a serial number in the form of an integer. 
YEARFRAC  2009 (V5) 
Engineering Functions  

BESSELI  2009 (V5) 
BESSELJ  2009 (V5) 
BESSELK  2009 (V5) 
BESSELY  2009 (V5) 
BIN2DEC  2009 (V5) 
BIN2HEX  2009 (V5) 
BIN2OCT  2009 (V5) 
BITAND  2017 (V8) 
BITLSHIFT  2017 (V8) 
BITOR  2017 (V8) 
BITRSHIFT  2017 (V8) 
BITXOR  2017 (V8) 
COMPLEX  2009 (V5) 
CONVERT  2009 (V5) 
DEC2BIN  2009 (V5) 
DEC2HEX  2009 (V5) 
DEC2OCT  2009 (V5) 
DELTA  2009 (V5) 
ERF  2009 (V5) 
ERF.PRECISE  2012 (V7) 
ERFC  2009 (V5) 
ERFC.PRECISE  2012 (V7) 
GESTEP  2009 (V5) 
HEX2BIN  2009 (V5) 
HEX2DEC  2009 (V5) 
HEX2OCT  2009 (V5) 
IMABS  2009 (V5) 
IMAGINARY  2009 (V5) 
IMARGUMENT  2009 (V5) 
IMCONJUGATE  2009 (V5) 
IMCOS  2009 (V5) 
IMCOSH  2017 (V8) 
IMCOT  2017 (V8) 
IMCSC  2017 (V8) 
IMCSCH  2017 (V8) 
IMDIV  2009 (V5) 
IMEXP  2009 (V5) 
IMLN  2009 (V5) 
IMLOG10  2009 (V5) 
IMLOG2  2009 (V5) 
IMPOWER  2009 (V5) 
IMPRODUCT  2009 (V5) 
IMREAL  2009 (V5) 
IMSEC  2017 (V8) 
IMSECH  2017 (V8) 
IMSIN  2009 (V5) 
IMSINH  2017 (V8) 
IMSQRT  2009 (V5) 
IMSUB  2009 (V5) 
IMSUM  2009 (V5) 
IMTAN  2017 (V8) 
OCT2BIN  2009 (V5) 
OCT2DEC  2009 (V5) 
OCT2HEX  2009 (V5) 
Financial Functions  

ACCRINT  2009 (V5) 
ACCRINTM  2009 (V5) 
AMORDEGRC  2009 (V5) 
AMORLINC  2009 (V5) 
COUPDAYBS  2009 (V5) 
COUPDAYS  2009 (V5) 
COUPDAYSNC  2009 (V5) 
COUPNCD  2009 (V5) 
COUPNUM  2009 (V5) 
COUPPCD  2009 (V5) 
CUMIPMT  2009 (V5) 
CUMPRINC  2009 (V5) 
DB  Returns the asset depreciation for a period using the fixed declining balance method. 
DDB  Returns the asset depreciation for a period using the doubledeclining balance method or another specified method. 
DISC  2009 (V5) 
DOLLARDE  2009 (V5) 
DOLLARFR  2009 (V5) 
DURATION  2009 (V5) 
EFFECT  2009 (V5) 
FV  Returns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments. 
FVSCHEDULE  2009 (V5) 
INTRATE  2009 (V5) 
IPMT  Returns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate. 
IRR  Returns the internal rate of return for a series of cash flows represented by numbers in the form of values. 
ISPMT  Calculates the interest paid during a defined period of an investment. 
MDURATION  2009 (V5) 
MIRR  Returns a modified internal rate of return for several periodic cash flows. 
NOMINAL  2009 (V5) 
NPER  Returns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate. 
NPV  Calculates the net present value of an investment from the discount rate and several future payments and income. 
ODDFPRICE  2009 (V5) 
ODDFYIELD  2009 (V5) 
ODDLPRICE  2009 (V5) 
ODDLYIELD  2009 (V5) 
PDURATION  2017 (V8) 
PMT  Calculates the loan payment for a loan based on constant payments and constant interest rates. 
PPMT  Returns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate. 
PRICE  2009 (V5) 
PRICEDISC  2009 (V5) 
PRICEMAT  2009 (V5) 
PV  Returns the present value based on an investment. 
RATE  Returns per period the interest of an annuity. 
RECEIVED  2009 (V5) 
RRI  2017 (V8) 
SLN  Returns the straightline depreciation on an asset. 
SYD  Based on a specified period, SYD returns the sumofyears' digits depreciation of an asset. 
TBILLEQ  2009 (V5) 
TBILLPRICE  2009 (V5) 
TBILLYIELD  2009 (V5) 
VDB  For a period you specify, returns the depreciation of an asset. 
XIRR  2009 (V5) 
XNPV  2009 (V5) 
YIELD  2009 (V5) 
YIELDDISC  2009 (V5) 
YIELDMAT  2009 (V5) 
Information Functions  

CELL  2012 (V7) 
ERROR.TYPE  Returns the corresponding number value associated with an error type in Microsoft Excel. 
INFO  Returns operating environment information. 
ISBLANK  Returns TRUE if the cell is empty, FALSE if it contains data. 
ISERR  Returns TRUE if value contains any error value except #N/A, FALSE if it does not. 
ISERROR  Returns TRUE if value contains any error value (including #N/A), FALSE if it does not. 
ISEVEN  2009 (V5) 
ISFORMULA  2017 (V8) 
ISLOGICAL  Returns TRUE if value is a logical value, FALSE if it is not. 
ISNA  Returns TRUE if value is #N/A, FALSE if it is not. 
ISNONTEXT  Returns TRUE if value is not text, FALSE if it is. 
ISNUMBER  Returns TRUE if value is a number, FALSE if it is not. 
ISODD  2009 (V5) 
ISREF  Returns TRUE if value is a reference, FALSE if it is not. 
ISTEXT  Returns TRUE if value is text, FALSE if it is not. 
N  Returns a value converted to a number. 
NA  An alternative representation of the error value #N/A. 
SHEET  2017 (V8) 
SHEETS  2017 (V8) 
TYPE  Determines the type of value in a cell. 
Logical Functions  

AND  Returns TRUE if all the arguments are TRUE in the formula, and FALSE if any one argument is FALSE. 
FALSE  Returns the value FALSE. May be typed directly into the cell as "FALSE". 
IF  Returns a value if one condition is TRUE and returns another value if the condition is FALSE. 
IFERROR  2012 (V7) 
IFNA  2017 (V8) 
NOT  Returns the reverse value of its arguments; TRUE becomes FALSE and FALSE becomes TRUE. 
OR  Returns FALSE if all arguments are FALSE, and TRUE if at least one argument is TRUE. 
TRUE  Returns the value TRUE. May be typed directly into the cell as "TRUE". 
XOR  2017 (V8) 
Lookup and Reference Functions  

ADDRESS  Given specified row and column numbers, creates a cell address as text. 
AREAS  Returns the number of areas based on a reference. 
CHOOSE  Returns an item from a list of values.. 
COLUMN  Returns the column number(s) based on a given reference. 
COLUMNS  Returns the number of columns based on an array or reference. 
HLOOKUP  Searches for a specified value in an array or a table's top row. 
HYPERLINK  Creates a shortcut to jump to a document stored on a network server. 
INDEX  Returns the value of an element selected by the row number and column letter indexes. 
INDIRECT  Returns the contents of a cell using its reference. 
LOOKUP  Looks in the first row or column of a range or array, and returns the specified value from the same position in the last row or column of the range or array. 
MATCH  Returns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item. 
OFFSET  Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells. 
ROW  Returns the row number based on a reference. 
ROWS  Returns the number of rows in a reference or array. 
TRANSPOSE  Returns a horizontal range of cells as vertical or vice versa. 
VLOOKUP  Searches for a value in the leftmost column of a table and returns a value from the same row in a column number that you specify. 
Math and Trigonometry Functions  

ABS  Returns the absolute value of a number. 
ACOS  Returns the arccosine of a number in radians in the range 0 to pi. 
ACOSH  Returns the inverse hyperbolic cosine of a number. 
ACOT  2017 (V8) 
ACOTH  2017 (V8) 
AGGREGATE  2017 (V8) 
ARABIC  2017 (V8) 
ASIN  Returns the arcsine of a number in radians in the range pi/2 to pi/2. 
ASINH  Returns the inverse hyperbolic sine of a number. 
ATAN  Returns the arctangent of a number in radians in the range pi/2 to pi/2 
ATAN2  Returns the fourquadrant arctangent of the specified x and y coordinates in radians between pi and pi excluding pi. A positive result represents a counterclockwise angle from the xaxis, a negative result represents a clockwise angle. 
ATANH  Returns the inverse hyperbolic tangent of a number. 
BASE  2017 (V8) 
CEILING  Returns a number rounded up, away from zero, to the nearest multiple of significance. 
CEILING.MATH  2017 (V8) 
CEILING.PRECISE  2012 (V7) 
COMBIN  Returns the number of combinations for a given number of items. 
COMBINA  2017 (V8) 
COS  Returns the cosine of the given angle. 
COSH  Returns the hyperbolic cosine of a number. 
COT  2017 (V8) 
COTH  2017 (V8) 
CSC  2017 (V8) 
CSCH  2017 (V8) 
DECIMAL  2017 (V8) 
DEGREES  Converts radians into degrees. 
EVEN  Returns a number rounded up to the next even integer for positive integers and rounded down to the next even integer for negative numbers. 
EXP  Returns e (2.71828182845804) raised to the power of a specified number. 
FACT  Returns the factorial of a number. 
FACTDOUBLE  2009 (V5) 
FLOOR  Returns a number rounded down, toward zero, to the nearest multiple of significance. 
FLOOR.MATH  2017 (V8) 
FLOOR.PRECISE  2012 (V7) 
GCD  2009 (V5) 
INT  Rounds a number down to the nearest integer. 
ISO.CEILING  2017 (V8) 
LCM  2009 (V5) 
LN  Returns the natural (base e) logarithm of a number. 
LOG  Returns the logarithm of a number of the base you specify. 
LOG10  Returns the base10 logarithm of a number. 
MDETERM  Returns the matrix determinant of an array. 
MINVERSE  Returns the inverse matrix for the matrix stored in an array. 
MMULT  Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. 
MOD  Returns the remainder of a division operation (modulus). 
MROUND  2009 (V5) 
MULTINOMIAL  Returns the ratio of the factorial of the sum of the values to the product of the factorials. 
MUNIT  2017 (V8) 
ODD  Returns a number rounded up away from zero to the nearest odd integer. 
PI  Returns the approximate number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. 
POWER  Returns the result of a specified number raised to a specified power. 
PRODUCT  Multiplies all the numbers given as arguments and returns the product. 
QUOTIENT  2009 (V5) 
RADIANS  Converts degrees to radians. 
RAND  Returns an evenly distributed random number greater than or equal to 0 and less than 1. A new random number is returned every time the worksheet is calculated. 
RANDBETWEEN  2009 (V5) 
ROMAN  Converts an Arabic numeral to Roman, as text. 
ROUND  Round a number to a specified number of digits. 
ROUNDDOWN  Rounds a number down, towards zero. 
ROUNDUP  Rounds a number up, away from zero. 
SEC  2017 (V8) 
SECH  2017 (V8) 
SERIESSUM  2009 (V5) 
SIGN  Determines the sign of a number. Returns 1 if the value is positive, 0 if the value is 0, and 1 if the value is negative. 
SIN  Returns the sine of a given angle. 
SINH  Returns the hyperbolic sine of a number. 
SQRT  Returns a positive square root. 
SQRTPI  2009 (V5) 
SUBTOTAL  Returns a subtotal in a list or database. 
SUM  Adds all the numbers in a range of cells. 
SUMIF  Adds the cells specified by a certain criteria. 
SUMIFS  2012 (V7) 
SUMPRODUCT  Multiplies corresponding components in the given arrays, and returns the sum of those products. 
SUMSQ  Returns the sum of the squares of the arguments. 
SUMX2MY2  Returns the sum of the difference of squares of corresponding values in two arrays. 
SUMX2PY2  Returns the sum of the sum of squares of corresponding values in two arrays. 
SUMXMY2  Returns the sum of squares of differences of corresponding values in two arrays. 
TAN  Returns the tangent of the given angle. 
TANH  Returns the hyperbolic tangent of a number. 
TRUNC  Truncates a number to an integer by removing the fractional part of a number. 
PreExcel 2010 Statistical Functions  

BETADIST  Returns the cumulative beta probability density function. 
BETAINV  Returns the inverse of the cumulative beta probability density function. 
BINOMDIST  Returns the individual term binomial distribution probability. 
CHIDIST  Returns the onetailed probability of the chisquared (X^2) distribution; the area in the right tail under the chisquared distribution curve. 
CHIINV  Returns the inverse of the onetailed probability of the chisquared (X^2) distribution. 
CHITEST  Returns the test for independence of the characteristics in a table. 
CONFIDENCE  Returns the confidence interval for a population mean. 
COVAR  Returns the covariance, the average of products of deviations, for each data point pair. 
EXPONDIST  Returns the exponential distribution. 
FDIST  Returns the F probability distribution. 
FINV  Returns the inverse of the F probability distribution. 
FTEST  Returns the result of an Ftest. 
GAMMADIST  Returns the gamma distribution. 
GAMMAINV  Returns the inverse of the gamma cumulative distribution. 
LOGINV  Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation. 
LOGNORMDIST  Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard deviation. 
MODE  Returns the most frequently occurring, or repetitive, number in an array or range of data. 
NEGBINOMDIST  Returns the negative binomial distribution. 
NORMDIST  Returns the normal cumulative distribution for the specified mean and standard deviation. 
NORMINV  Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. 
NORMSDIST  Returns the standard normal cumulative distribution function. 
PERCENTILE  Returns the kth percentile of values in a range. 
PERCENTRANK  Returns the rank of a value in a data set set as a percentage of the data set. 
POISSON  Returns the Poisson distribution. 
QUARTILE  Returns the quartile of a data set. 
RANK  Returns the rank of a number in a list of numbers. 
STDEV  Estimates standard deviation based on a sample. 
STDEVP  Estimates standard deviation based on a sample assuming that the arguments represent the total population. 
TDIST  Returns the percentage points (probability) for the student tdistribution, where a numeric value (x) is a calculated value of t for which the percentage points are to be computed. 
TINV  Returns the tvalue of the Student's tdistribution as a function of the probability and the degrees of freedom. 
TTEST  The probability associated with ttest. 
VAR  Returns an estimate for the variance of a population based on a sample data set. 
VARP  Calculates variance based on the entire population. 
WEIBULL  Returns the Weibull distribution. 
ZTEST  Returns the twotailed Pvalue of a ztest. 
Statistical Functions  

AVEDEV  Returns the average of the absolute deviations of data points from their mean. 
AVERAGE  Returns the average of its arguments. 
AVERAGEA  Returns the average of the values in its list of arguments including text and logical values. 
AVERAGEIF  2012 (V7) 
AVERAGEIFS  2012 (V7) 
BETA.DIST  2012 (V7) 
BETA.INV  2012 (V7) 
BINOM.DIST  2012 (V7) 
BINOM.DIST.RANGE  2017 (V8) 
BINOM.INV  2012 (V7) 
CHISQ.DIST  2012 (V7) 
CHISQ.DIST.RT  2012 (V7) 
CHISQ.INV  2012 (V7) 
CHISQ.INV.RT  2012 (V7) 
CHISQ.TEST  2012 (V7) 
CONFIDENCE.NORM  2012 (V7) 
CONFIDENCE.T  2012 (V7) 
CORREL  Returns the correlation coefficient between two data sets. 
COUNT  Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments. 
COUNTA  Counts the number of cells that are not empty. 
COUNTBLANK  Counts the empty cells in a specified range. 
COUNTIF  Counts the number of cells in a range that meet a given criteria. 
COUNTIFS  2012 (V7) 
COVARIANCE.P  2012 (V7) 
COVARIANCE.S  2012 (V7) 
CRITBINOM  Returns the minimum number yields a binomial distribution less than or equal to the specified criteria 
DEVSQ  Returns the sum of the squares of deviations of a data set from their sample mean. 
EXPON.DIST  2012 (V7) 
F.DIST  2012 (V7) 
F.DIST.RT  2012 (V7) 
F.INV  2012 (V7) 
F.INV.RT  2012 (V7) 
F.TEST  2012 (V7) 
FISHER  Returns the Fisher transformation at x. 
FISHERINV  Returns the inverse of the Fisher transformation at y. 
FORECAST  Calculates or predicts a future value by using existing values. 
FREQUENCY  Calculates how often values occur within a range of values and then returns a vertical array of numbers. 
GAMMA  2017 (V8) 
GAMMA.DIST  2012 (V7) 
GAMMA.INV  2012 (V7) 
GAMMALN  Returns the natural logarithm of the gamma function. 
GAMMALN.PRECISE  2012 (V7) 
GAUSS  2017 (V8) 
GEOMEAN  Returns the geometric mean of an array or range of positive data. 
GROWTH  Calculates predicted exponential growth by using existing data. 
HARMEAN  Returns the harmonic mean of a data set. 
HYPGEOM.DIST  2012 (V7) 
HYPGEOMDIST  Returns the hypergeometric distribution. 
INTERCEPT  Calculates the point at which a line will intersect the yaxis by using existing x and y values. 
KURT  Returns the Kurtosis of a data set. 
LARGE  Returns the kth largest value in a data set. 
LINEST  Calculates a straight line that best fits your data using the least squares method. 
LOGEST  Calculates an exponential curve that fits your data and returns an array of values that describes the curve. 
LOGNORM.DIST  2012 (V7) 
LOGNORM.INV  2012 (V7) 
MAX  Returns the largest value in a set of values. 
MAXA  Returns the largest value in a set of values including text and logical values. 
MEDIAN  Returns the median of the given numbers. 
MIN  Returns the smallest value in a set of values. 
MINA  Returns the smallest value in a set of values including text and logical values. 
MODE.MULT  2012 (V7) 
MODE.SNGL  2012 (V7) 
NEGBINOM.DIST  2012 (V7) 
NORM.DIST  2012 (V7) 
NORM.INV  2012 (V7) 
NORM.S.DIST  2012 (V7) 
NORM.S.INV  2012 (V7) 
NORMSINV  Returns the inverse of the standard normal cumulative distribution function. 
PEARSON  Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from 1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets. 
PERCENTILE.EXC  2012 (V7) 
PERCENTILE.INC  2012 (V7) 
PERCENTRANK.EXC  2012 (V7) 
PERCENTRANK.INC  2012 (V7) 
PERMUT  Returns the number of permutations for a given number of objects that can be selected from a range of numbers. 
PERMUTATIONA  2017 (V8) 
PHI  2017 (V8) 
POISSON.DIST  2012 (V7) 
PROB  Returns the probability that values in a range are between two specified limits. 
QUARTILE.EXC  2012 (V7) 
QUARTILE.INC  2012 (V7) 
RANK.AVG  2012 (V7) 
RANK.EQ  2012 (V7) 
RSQ  Returns the r^2 value of a linear regression line. 
SKEW  Returns the skew of a distribution. 
SKEW.P  2017 (V8) 
SLOPE  Returns the slope of a regression line through data points in KNOWN_Y'S and KNOWN_X'S. 
SMALL  Returns the kth smallest value in a data set. 
STANDARDIZE  Returns a normalized value from a distribution characterized by MEAN and STANDARD_DEV. 
STDEV.P  2012 (V7) 
STDEV.S  2012 (V7) 
STDEVA  Estimates standard deviation based on a sample. Includes text and logical values. 
STDEVPA  Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values. 
STEYX  Returns the standard error of the predicted y value for each x in the regression. 
T.DIST  2012 (V7) 
T.DIST.2T  2012 (V7) 
T.DIST.RT  2012 (V7) 
T.INV  2012 (V7) 
T.INV.2T  2012 (V7) 
T.TEST  2012 (V7) 
TREND  Returns the yvalues along a linear trendline that best fits the values in a data set. 
TRIMMEAN  Returns the mean of the interior of a data set. 
VAR.P  2012 (V7) 
VAR.S  2012 (V7) 
VARA  Returns an estimate for the variance of a population based on a sample data set and may include text or logical values. 
VARPA  Calculates variance based on the entire population and may include text or logical values. 
WIEBULL.DIST  Returns the Weibull distribution. 
Z.TEST  2012 (V7) 
Text Functions  

CHAR  Returns the character specified by a number. 
CLEAN  Removes all nonprintable characters from text. 
CODE  Returns a numeric code from the first character in a text string. The opposite of the CHAR function. 
CONCATENATE  Joins several text strings into one text string. 
DOLLAR  Converts a number to text using Currency format, with the decimals rounded to the specified place. 
EXACT  Compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise. 
FIND  Locates one text string within another text string, and returns the number of the starting position of FIND_TEXT from the leftmost character of WITHIN_TEXT. 
FINDB  Returns the position of specified text within another specified text string based on the number of bytes each character uses from the first character of WITHIN_TEXT. 
FIXED  Rounds a number to a specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. 
LEFT  Returns the first character(s) in a text string. 
LEFTB  Returns the first character(s) in a text string based on a specified number of bytes 
LEN  Returns the number of characters in a text string. 
LENB  Returns the number of characters in a text string expressed in bytes. 
LOWER  Converts all letters in a text string to lowercase. 
MID  Returns a specific number of characters from a text string starting at the position you specify. 
MIDB  Returns a group of characters based on a specified number of bytes from a text string starting at the position you specify. 
NUMBERVALUE  2017 (V8) 
PROPER  Capitalizes the first letter of each word in a text string or sentence. 
REPLACE  Replaces part of a text string with a different text string based on the number of characters you specify. 
REPLACEB  Replaces part of a text string with a different text string based on the number of characters you specify in terms of bytes. 
REPT  Repeats specified text a given number of times. 
RIGHT  Returns the last character(s) in a text string. 
RIGHTB  Returns the last character(s) in a text string based on a specified number of bytes. 
SEARCH  Returns the number of the character at which a specific character or text string is first found, reading from left to right. 
SEARCHB  Returns the number of the character at which a specific character or text string is first found in bytes, reading from left to right. 
SUBSTITUTE  Substitutes NEW_TEXT for OLD_TEXT in a string. 
T  Returns the text referred to by a value. 
TEXT  Converts a value to text in a specific number format. 
TRIM  Removes all spaces from text except single spaces between words. 
UNICHAR  2017 (V8) 
UNICODE  2017 (V8) 
UPPER  Converts text to uppercase. 
USDOLLAR  Converts a number to text using US Dollar format, with the decimals rounded to the specified place. 
VALUE  Converts a text string that represents a number to a number. 
Web Functions  

ENCODEURL  2017 (V8) 
FILTERXML  2017 (V8) 
WEBSERVICE  2017 (V8) 