Percentage calculation

Closed
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I want to create a calcualtion for percentages in excel.
I will have basic percentages but the ones I am having issues with are those that the numerator is higher then the denominator, for example if we spent 125 but planned to spend 100. We are over plan but want to show that over plan as a negative % and not 125%.

Thanks,

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
what about this formula

=(100/125)-1
the formula is 125/100, should that be 1-(125/100) then so that the result is -25%??

how would I right that in an if statement if have regular percentages and then cases like this?
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
what is the concept? what is the basis. The basis is what is planned. Planned is 100 and actually spent 125. That means you spent 25 more than you planned that means 25 percent MORE. That is difference between planned and actual is positive. so you use =(125/100)-1.

as you are sure of your concept you can manipulate the formula.