2 Replies Latest reply: Nov 15, 2012 6:54 PM by queenauntie3
Level 1

I am sooo close- I want to compare the percent difference between two columns- to compare the total in column B to total in column C-- to establisha  percent of difference be it less than or greater---help

MacBook, Mac OS X (10.7.5), time capsule
Solved by Barry on Nov 15, 2012 5:59 PM Solved
What's missing from your description is which column holds the base amount for the calculation. I;ll assume the original amount is in B, the changes amount is in C, and you want to know the percentage change that has occured from B. In column D, enter =(C-B)/BFormat the result as a percent, with the number of places after the decimal that you require.Note: The result in row 7 looks odd, but is correct to the nearest tenth of a percent.  Regards,Barry
• Level 7

What's missing from your description is which column holds the base amount for the calculation. I;ll assume the original amount is in B, the changes amount is in C, and you want to know the percentage change that has occured from B.

In column D, enter =(C-B)/B

Format the result as a percent, with the number of places after the decimal that you require.

Note: The result in row 7 looks odd, but is correct to the nearest tenth of a percent.

Regards,

Barry

• Level 1

YOU ARE THE GREATEST--- THANK YOU SO MUCH!! I wanted to compare productivity from last year's production (significantly higher) to the current year--- I set column B as 2011 and column C as 2012-- I want to see the variance differenct-- this appears to have solved it-- any further suggestions would be appreciated