Results 1 to 9 of 9

Minus a percentage in a formula

This is a discussion on Minus a percentage in a formula within the Excel Questions forums, part of the Question Forums category; I need to write a formula to minus a percentage of a total. for example I want to take away ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Posts
    7

    Default

    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. #2
    Board Regular XL-Dennis's Avatar
    Join Date
    Jul 2002
    Location
    Östersund, Sweden
    Posts
    1,922

    Default

    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
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    322

    Default

    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. #4
    New Member
    Join Date
    Feb 2010
    Posts
    3

    Default Re: Minus a percentage in a formula

    Even simpler:

    A1: £8.75

    =A1*(1-20%)

  5. #5
    New Member
    Join Date
    Feb 2012
    Location
    Stoclholm
    Posts
    1

    Default Re: Minus a percentage in a formula

    Quote Originally Posted by rossmolden View Post
    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. #6
    New Member
    Join Date
    Aug 2014
    Posts
    3

    Default Re: Minus a percentage in a formula

    Quote Originally Posted by rossmolden View Post
    Even simpler:

    A1: £8.75

    =A1*(1-20%)



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

  7. #7
    Board Regular
    Join Date
    Jun 2013
    Location
    Ashford, Surrey
    Posts
    192

    Default Re: Minus a percentage in a formula

    Basic maths!!

  8. #8
    New Member
    Join Date
    Aug 2014
    Posts
    3

    Default Re: Minus a percentage in a formula

    Sarcasm not required!

  9. #9
    Board Regular
    Join Date
    Jun 2013
    Location
    Ashford, Surrey
    Posts
    192

    Default Re: Minus a percentage in a formula

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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com