# Percentage Decrease greater than 100%

#### stewartc3

##### New Member
Hi, I've been racking my brain around this and hope someone can help. Is there a formula that will look at 2 numbers and if the first number is greater to calculate a percentage increase, but if it's smaller to calculate a percentage decrease.
In the screenshot example, L18 is less than L7 and should be = 58.6716% decrease, but it's showing as 142% decrease in M18.
There are times though that L18 will be greater than L7 so I guess I'm looking for some sort of if formula?
Any help would be greatly appreciated.
I'm using office 365
Thank you!
Chris

#### Attachments

• excel screenshot.png
155.4 KB · Views: 2

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

=(L18/L7)-1

#### DeficientOptimism

##### New Member
You were going wrong by dividing by L18 and not L7. You’re looking for the percentage decrease from the last data point, therefore L7 as the denominator.

Alternatively, if you try (L18-L7)/L7, you will find the same answer as above.

Replies
1
Views
210
Replies
3
Views
150
Replies
8
Views
315
Replies
3
Views
341
Replies
6
Views
607

1,127,449
Messages
5,624,827
Members
416,057
Latest member
VARSHA V VASWANI

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