# Calculate X Percentage Of Cost

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

• 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

• 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

-------------
[FONT="Comic Sans MS"]Averil Pretty[/FONT]

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

-------------
[FONT="Comic Sans MS"]Averil Pretty[/FONT]

• 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

-------------
[FONT="Comic Sans MS"]Averil Pretty[/FONT]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!