Previous Topic Next Topic

Percentage calculation

Closed
Viaes - Jan 28, 2010 at 01:45 PM
venkat1926 Posts 1863 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 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 28, 2010 at 08:43 PM
what about this formula

=(100/125)-1
3
Viaes
Jan 29, 2010 at 09:57 AM
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
Answer 2 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

Percentage calculation
dany -
m.thenmozhi -

2 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
Calculator percentage
Chin Fong -
Excelguru -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response