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

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
  • 1. Re: NUMBERS- variance difference- how to set a function
    Barry Level 7 Level 7 (29,180 points)

    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.

    Picture 5.png

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

     

    Regards,

    Barry

  • 2. Re: NUMBERS- variance difference- how to set a function
    queenauntie3 Level 1 Level 1 (0 points)

    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