I am trying to create a simple formula to extract cost from a total that includes both cost and and a percentage for maintanance.
Assume $100, 10% of which is maintenance the remainder is cost. If I just subtract 10% from $100 I get $90, however 10% of $90 is $9 which equals $99. Any assistance is greatly appreciated.
Calculate X Percentage Of Cost
-
-
-
Re: Calculation To Extract Cost
=90*0.1
Or
=90*10% -
Re: Calculate X Percentage Of Cost
I know it is pretty simple for $100 however I am looking at $733,406.33 10% of which is maitenance. I am trying to extract the cost. The cost + 10% = 733,406.33
Thanks in advance...
-
Re: Calculate X Percentage Of Cost
The number value has no bearing on the calculation method.
-
Re: Calculate X Percentage Of Cost
Cost * 1.1
-
-
Re: Calculate X Percentage Of Cost
I get #VALUE! with that formula
-
Re: Calculate X Percentage Of Cost
Sorry Dave, I know you know what I meant, but I should have clarified...
If your initial value/cost is in cell A2, put =A2*1.1 in the cell where you want the calculated value returned.
A better option if you have lots of rows especially if there is the likliehood of the % amount changing would be to store the percentage (in this case 10%) in say cell A1, then use the formula =A2+(A2*$A$1) where you want the result, and copy it down. This means you wouldn't need to change each formula if the % changes, just the one cell (A1).
Cheers,
-
Re: Calculate X Percentage Of Cost
I was joking by taking a cotton wooled shot at jesselee. Hence the wink smiley
-
Re: Calculate X Percentage Of Cost
All good
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!