What are the formulas for Microsoft Excel?
“A formula identifies the calculation needed to place the result in the cell it is contained within. A cell containing a formula therefore has two display components; the formula itself and the resulting value. The formula is normally only shown when the cell is selected by “clicking” the mouse over a particular cell; otherwise it contains the result of the calculation. A formula assigns values to a cell or range of cells, and typically has the format: =expression where the expression consists of: values, such as 2, 9.14 or 6.67E-11; references to other cells, such as, e.g., A1 for a single cell or B1:B3 for a range; arithmetic operators, such as +, -, *, /, and others; relational operators, such as >=, <, and others; and, functions, such as SUM(), TAN(), and many others. When a cell contains a formula, it often contains references to other cells. Such a cell reference is a type of variable. Its value is the value of the referenced cell or some derivation of it. If that cell in turn re
As Brian has started to explain, formulas in Excel start with “=” (no quotation marks) and include various combinations of Excel FUNCTIONS (SUM, AVERAGE, IF, AND, NOT, OR, COUNTIF, SUMPRODUCT, YEAR, etc.), OPERATORS (+, -, *, /), CHECKS for equality and inequality (=, >, <, >=, <=), RANGES (J9, A1:A10, Monthly_Sales -- if you have Named Ranges) and CONSTANTS to examine and manipulate data. There is no possible way to list "the formulas" for Excel, because the number and complexity is limited only by your imagination, the permitted syntax ... and Excel's capability to store long equations.
