MS Excel table creation formula
MS Excel table formulas are the bread and butter of the worksheet. Without formulas, the worksheet would be just a simple tabular representation of the data. A formula consists of a special code entered into a cell. It performs some calculations and returns the result, which is displayed in the cell.
Formulas use various operators and worksheet functions to work with values and text. Values and text used in formulas can be in other cells, which makes it easy to change data and makes worksheets dynamic. For example, you can quickly change data in worksheets and formulas.
elements of a formula
A formula can consist of any of these elements −
Mathematical operators such as + (for addition) and * (for multiplication) Examples:
=A1+A2 adds the values in cells A1 and A2.
Value or text example:
=200*0.5 times 200 times 0.15. This formula uses only values and always returns the same result as 100.
Example of cell references (including named cells and ranges):
=A1=C12 Compares cell A1 with cell C12. The formula returns TRUE if the cells are the same; otherwise, it returns FALSE.
Examples of worksheet functions (such as SUor AVERAGE):
=SUM(A1:A12) adds the values in the range A1:A12.
To create a formula, you need to type in the formula bar. The formula begins with an “=” sign. When building formulas manually, you can enter cell addresses or point to them in the worksheet.
Using the point-to method to provide cell addresses for formulas is generally a simpler and more powerful method of formula building.
When using built-in functions, click a cell or drag the range of cells you want to use when defining the function’s arguments in the Function Arguments dialog box. See the screenshot below.
As soon as you finish entering the formula, Excel calculates the result and then displays the result in a cell on the worksheet (however, the contents of the formula continue to be visible on the formula bar as long as the cell is active).
If an error in a formula prevents Excel from calculating the formula at all, Excel displays a warning dialog with suggestions on how to fix the problem.