Another excel question percentages

Ladywriter1968

Say I have £200 and I want to take off 20%. Or Add 20%. Either way:

What is the formula for this so it can work it out for you?

Sometimes when you ask excel it does not always come up.

ceebeeby

=sum(200)-(200/100)*20 for 20% off
or
=sum(200)+(200/100)*20 for 20% more

.... I think

Mobeer

If you had the number pounds in cell A1 (eg 200), the percentage in B1 (eg 20) then the formula I would use is
=A1*(1+B1/100)

To subtract 20% just make the value in cell B1 negative.

The_Grandmaster

A1: 200 (say)
B1: 1+ put in your percentage positive or negative/100 eg. 1+20/100 or 1-20/100
C1: =A1*B1

tomstickland

New value = old value * (1 + percentage/100)

Eg: cell A1 coutains a number that represents the percentage, formatted as a number, not a percentage.

A2 contains old value
A3 = A2 * (1 + A1/100)

if A1 is formatted as a percentage then
A3 = A2 * (1 + A1)

PhilCo_2

You can use a % in the calc as well. e.g =A1-(A1*20%) or if you have 20% entered in another cell just enter the cell reference instead.