Question

Insert a calculated field named Difference that subtracts the Qtr1 field amount from the Qtr4 field amount. In cell E2, use +/- Q4 to Q1 as the column label.

Answer 1

To insert a calculated field named Difference that subtracts the Qtr1 field amount from the Qtr4 field amount, follow these steps: 1. Select the cell where you want to insert the calculated field. 2. In the formula bar, type the formula =Qtr4 - Qtr1. 3. Press Enter to calculate the difference. 4. To change the column label to +/- Q4 to Q1, select the cell where the column label is located and type +/- Q4 to Q1.

To insert a calculated field named Difference that subtracts the Qtr1 field amount from the Qtr4 field amount, follow these steps:

1. Select the cell where you want to insert the calculated field.
2. In the formula bar, type the formula =Qtr4 - Qtr1.
3. Press Enter to calculate the difference.
4. To change the column label to +/- Q4 to Q1, select the cell where the column label is located and type +/- Q4 to Q1.

Example: If Qtr4 field amount is 100 and Qtr1 field amount is 80, the calculated field (Difference) will be 100 - 80 = 20.