# Minus a percentage in a formula

#### walkera

##### New Member
I need to write a formula to minus a percentage of a total.

for example I want to take away 20% of the total of £8.75.

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
On 2002-08-28 04:13, walkera wrote:
I need to write a formula to minus a percentage of a total.

for example I want to take away 20% of the total of £8.75.

Try following:
A1: 8.75
A2: 20%
A3: =A1*(1-A2)

Kind regards,
Dennis

Not quite as elegant but you can do it in one cell

a1: £8.75

a2: =((a1/100)*80)

alternativly

if the % deduction changes

a1: Percentage to deduct eg. 20% 30% etc..

a2: Amount eg. £8.75, £9.15 etc

cell b1: = ((\$a\$2/100)*\$a\$1)

Or if the amount changes

Col C= Amount eg c1 £8.75
Col D = ((c1/100)*\$a\$1)

You can then drag the formula down column D

For this one keep the format of cell A1 as a number NOT Percentage.

Remember you can use the F4 key to lock the absolute references.

Hope this helps.

DaveA
This message was edited by applebyd on 2002-08-28 04:50

Even simpler:

A1: £8.75

=A1*(1-20%)

Even simpler:

A1: £8.75

=A1*(1-20%)

What about if i need to deduct 60%, well its actually SEK100 -50% -20%?

I´v tried A1: 100

=A1*(1-50%-20%)

And

=A1*(1-50%)*(1-20%)
It sould give me the answer (23,2)...

Even simpler:

A1: £8.75

=A1*(1-20%)

Fantastic!, thank you you have just saved me a lot of calculation time!!!

Basic maths!!

Sarcasm not required!

The formula is exactly the same as what would be done on a calculator, though.

Replies
4
Views
45
Replies
6
Views
104
Replies
20
Views
449
Replies
3
Views
108
Replies
7
Views
124

1,196,380
Messages
6,014,956
Members
441,857
Latest member
saraguchi2316

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back