Thanks:  0
Likes:  0

# Thread: Minus a percentage in a formula

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

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

3. 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 ]

4. ## Re: Minus a percentage in a formula

Even simpler:

A1: £8.75

=A1*(1-20%)

5. ## Re: Minus a percentage in a formula

Originally Posted by rossmolden
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)...

6. ## Re: Minus a percentage in a formula

Originally Posted by rossmolden
Even simpler:

A1: £8.75

=A1*(1-20%)

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

7. ## Re: Minus a percentage in a formula

Basic maths!!

8. ## Re: Minus a percentage in a formula

Sarcasm not required!

9. ## Re: Minus a percentage in a formula

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•