# Create an Excel Formula

In Excel, if you want to perform a mathematical calculation such as addition, subtraction, multiplication, or division, use a formula. Type the formula in the cell where you want the results to appear. The formula should start with an equal sign, and can consist of numbers, mathematical operators, references, logical values, and functions, or any combination thereof. For now, we will stick with numbers, cell references, and mathematical operators. We will discuss each of the other options, later.

Mathematical operators tell Excel the type of mathematical calculation you want to perform. For example, the plus sign (+) tells Excel to add and the minus sign (-) tells Excel to subtract. The following Mathematical Operators table lists all of Excel's operators.

Mathematical Operators
Symbol Calculation Type Formula Result
- Subtraction =4-3 1
- Negation =-1 -1
* Multiplication =2*3 6
/ Division =6/2 3
^ Exponential (Raises to a power) =3^2 9
% Percent =10% 10%

To reference a cell, include the cell address in the formula. If the cell contains a number, Excel will use the number in the calculation. If the cell contains text that is not in a format that Excel recognizes as a number, Excel will return an error. For example, if cell A1 contains the number 1, the formula = A1+1 returns 2. If you change the number in the cell, the results of the calculation will change. For example, if you change the number in cell A1 to 2, = A1+1 returns 3. If you change the value in cell A1 to Sales, = A1+1 returns the error #VALUE.

When creating a formula, be mindful of precedence. Precedence is the order in which Excel performs calculations. Excel uses the following order:

• Negation (-10)
• Percent (%)
• Power (^)
• Multiplication and division