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