Question: 1 . Insert another calculated field named % Difference that subtracts the Qtr 1 field amounts from the Qtr 4 field amounts, and then divides

1. Insert another calculated field named % Difference that subtracts the Qtr 1 field amounts from the Qtr 4 field amounts, and then divides the result by the Qtr 1 field amount. In cell F2, use % Q4 to Q1 as the column label. Change the number format of the % Q4 to Q1 amounts to Percentage with 2 decimal points.
The formulas I have:
1 Difference ='Qrt 4'-'Qrt 1'
2% Difference =('Qrt 4'-'Qrt 1')/'Qrt 1'
I am getting large percentages for % Q4 to Q1?
Please help, Thank you!
QUALEY
SALES BY SERVICE
1 . Insert another calculated field named %

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!