# Need help with a formula

#### abeagle

##### New Member
HI there,

I have a spreadsheet comparing sales from one year to the next and I need a formula that will show the percentage of increase or decrease between the two. Can anyone help with this? Let me know if I need to clarify this a bit more. I'm self taught on Excel and do pretty well, but I'm missing some basic knowledge. Thank you!

Andrea

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### shajueasow

##### Well-known Member
Welcome to the board.
Assumed that Column A & B contains sales of two years.
The in cell C1 enter the formula =a1/b1, and format cell C1 to show % (Format>Cells>Category>Percentage)
The more details posted the better answer you will get.
So post more details if needed.

#### sykes

##### Well-known Member
Hi Andrea, and welcome to Mr Excel!

Assuming last year's sales in A1, and this year's in B1, then this formula in C1:

= IF(A1>B1,ROUND((A1-B1)*100/A1,2) & "% increase in sales", ROUND((B1-A1)*100/A1,2) & "% decrease in sales")

........should produce the desired results.

Let us know.........

#### abeagle

##### New Member
Thank you both so much for your help! I got what I need, for now. I'll post again if I run into problems. Thanks again!!!

Replies
1
Views
198
Replies
17
Views
352
Replies
6
Views
191
Replies
36
Views
1K
Replies
3
Views
243

Threads
1,171,165
Messages
5,874,142
Members
433,028
Latest member
bressler4534

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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