Boards
People good at EXCEL
please help me with your wisdom. OK say in:
A1 - 4
B1 - 5
And you want to work out the % change from A1 to B1. It would be
100-((A1/B1)*100) which will give you 20%.
BUT
say in
C1 - 5
D1 - 4
if you do 100-((C1/D1)*100) you get 25%. That's not right :s
If you change it to D1/C1 yeah you get 20% but is there a different way of doing this?