Question: 1 . Insert another calculated field named % Difference that subtracts the Qtr 1 field amounts from the Qtr 4 field amounts, and then divides
Insert another calculated field named Difference that subtracts the Qtr field amounts from the Qtr field amounts, and then divides the result by the Qtr field amount. In cell F use Q to Q as the column label. Change the number format of the Q to Q amounts to Percentage with decimal points.
The formulas I have:
Difference Qrt Qrt
Difference Qrt Qrt Qrt
I am getting large percentages for Q to Q
Please help, Thank you!
QUALEY
SALES BY SERVICE
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
