Percentage calculation

Closed
Viaes - Jan 28, 2010 at 01:45 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 29, 2010 at 08:38 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jan 28, 2010 at 08:43 PM
what about this formula

=(100/125)-1
3
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?
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jan 29, 2010 at 08:38 PM
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.
0