Currently Being ModeratedNov 15, 2012 5:59 PM (in response to queenauntie3)
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.
Currently Being ModeratedNov 15, 2012 6:54 PM (in response to queenauntie3)
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