Help with 2 Formulas

[SuzNZ]

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

 

[venkat1926]

1. the first formula is
=(B1-A1)/A1

2. fro the second question the formula is
=(C2-C1)/C2

Format both the results in percentage with no decimal places.

 

[Legacy 63186]

the first formula should be =(A2-A1)/A1