Formulas

A spreadsheet formula is an equation that performs a calculation on the numbers, functions and values of one or more cells. A formula is associated with a cell or a cell range

You can create formulas and perform calculations of any complexity. The Formula Bar that allows you to view, enter, and edit formulas.The Spreadsheet  supports over 400 built-in functions designed to address a broad range of usage scenarios. You can use basic mathematical functions to aggregate data within a spreadsheet or create complex formulas with statistical, engineering, and financial functions. In addition to the predefined functions, the Spreadsheet control also supports user-defined (custom) functions.

Features of Formulas

Name Box

A Name Box is a part of the Formulas Tab that displays a cell reference to the currently active cell.

A cell reference is a set of coordinates that specify the position of a cell or cell range on a worksheet cells.
The results of formulas that use cell references are automatically updated each time the values of these cells are changed.

If a cell range selected in a worksheet has a name, the name box displays the range name, as well as a table, picture or chart name when the corresponding object is selected.
The name box also allows end-users to create workbook level defined names for cells, and quickly navigate to cells by their references and names.

Name Manager

The Name Manager dialog lists all defined names contained in the workbook and allows you to:
 

Create New Name
To create a new name click the New… button in Name Manager invokes the new name window where you can specify all necessary parameters for a new defined name.
This dialog is also invoked on clicking the Defined Name button on the Formulas Ribbon tab in the Defined Names group.
When creating and modifying defined names, follow the rules below.

•Start a name with a letter, the underscore symbol (“_”) or the backslash (“\“). The remaining characters in the name can be letters, numbers, periods and underscore symbols.

Note that the single letters “C”, “c”, “R”, or “r” cannot be used as defined names.

•A name cannot be the same as a cell reference (for example, “A1”, “$M$15”, etc.).

•A name cannot contain spaces (use underscore symbols and periods instead).

•A name cannot be an empty string.

•The length of a name cannot exceed 255 characters.

•Names are case-insensitive. For example, you are not allowed to create the Products and PRODUCTS names in one scope.

A new name can be also created via the name box or the Create Names from Selection dialog.
However, the New Name dialog gives you more flexibility. For example, it allows you to specify any worksheet as the scope of the defined name, or create a comment for the name.

Delete Name
To delete a defined name from the document, it is necessary to select the name in the Name Manger dialog, and click the Delete button (or press the DELETE key).
 
Change name

An existing defined name can be modified via the Edit Name dialog. It is invoked when an end-user selects a name in the Name Manger dialog and clicks the Edit… button, or double-clicks the name. This dialog allows you to modify the name itself, change the cell reference, formula or constant to which the name refers, or enter a new comment. Only the scope of the defined name cannot be changed.
To change a cell range associated with a name, an end-user can type a new range reference in the Refers to editor, or click the Collapse Dialog button and select the desired range directly in the worksheet.
After a new value is entered in the Refers to editor, the Commit and Cancel buttons become available to save or cancel the changes.