Hi
I need help with 2 formulas please;
1) % change between 2 numbers
so if I have 100 in A1 and 125 in A2 what formula do I need to return and answer to say the % change is 25%
2) working out Margin % when I have a Buy Price and a RRP price
If I have $100 in c1 and and $111.11 in c2 what formula do I need to return an answer to say the Margin is 10%
Thanks heaps
I need help with 2 formulas please;
1) % change between 2 numbers
so if I have 100 in A1 and 125 in A2 what formula do I need to return and answer to say the % change is 25%
2) working out Margin % when I have a Buy Price and a RRP price
If I have $100 in c1 and and $111.11 in c2 what formula do I need to return an answer to say the Margin is 10%
Thanks heaps