Posted on 2013-12-05
i am simply trying to calculate the percentage difference between two columns and check against the third column to see how much is the difference
A1 B1 C1 D1 E1
282 134 33 (B1-A1/A1)*100 = -52.48%
From the above, I have figured out the formula to find the percentage difference between b1 and a1, now I need to check if I am -52% down on the number comparing it with C1
I mean, what will the value in E1 if I take away 52.48% from C1
I hope you understand what I am trying to say?