# Help with 2 Formulas

#### SuzNZ

##### New Member
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

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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.

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

Replies
1
Views
126
Replies
27
Views
2K
Replies
1
Views
205
Replies
5
Views
174
Replies
5
Views
292

1,219,918
Messages
6,150,961
Members
450,996
Latest member
darko1515s

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back