Percentage Decrease greater than 100%

stewartc3

New Member
Joined
Jan 5, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
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
    excel screenshot.png
    155.4 KB · Views: 2

Some videos you may like

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

DeficientOptimism

New Member
Joined
Jan 19, 2021
Messages
12
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

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

Which adblocker are you using?

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
Top