Excel uses a default order where calculations take place. If there is a portion of the formula in the parentheses, that portion is determined first. It the conducts calculations for multiplication or division. Excel will add and subtract the remainder of formula until this is done. See the following example.
Excel performs multiplication first (A1 * A2). Next, Excel adds the value of cell A3 to this result.
Another example,
Excel calculates the part in parentheses first (A2+A3). Next, it multiplies this result by the value of cell A1.
Copy/Paste a Formula
When you copy a formula, Excel changes the cell references automatically for each new cell to which the formula is copied. Conduct the following steps to grasp this.
1. On cell A4, enter the formula shown below.
2a. Choose cell A4, right click, and then click Copy (or press CTRL + c).
…next, choose cell B4, right click, and then click Paste under ‘Paste Options:’ (or press CTRL + v).
2b. You can also drag the formula to cell B4. Choose cell A4, click on the lower right corner of cell A4 and drag it across to cell B4. This is efficient and provides the exact result simultaneously!
Outcome. The formula in cell B4 references the values in column B.
