+ Reply to Thread
Results 1 to 4 of 4

Formula Help subtracting Percentages

  1. #1
    Registered User
    Join Date
    09-14-2016
    Location
    Winchester, KY
    MS-Off Ver
    365 Desktop
    Posts
    19

    Formula Help subtracting Percentages

    So I am trying to create a spreadsheet to help my mom track her sales on a particular website. I want the formula to figure out her take home after all the fees. Below is what I am trying to accomplish but I can't get a formula that works. Please help me.

    Price (E2)-2.5
    total of above x sum of F2+G2
    total of above -2.9%

    My current formula is =(E2-2.5)*(F2+G2)-(0.029)

    I Also need
    Price (E2) x sum of F2+G2
    total of above - 20%
    Total of above -2.9%

    My current formula is =((D2*(E2+F2)-(20%)))-0.029

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,057

    Re: Formula Help subtracting Percentages

    1st formula = (E2-2.5)*(F2+G2)*(1-2.9%)
    2nd formula = (D2*(E2+F2)*(1-20%)*(1-2.9%)

  3. #3
    Registered User
    Join Date
    09-14-2016
    Location
    Winchester, KY
    MS-Off Ver
    365 Desktop
    Posts
    19

    Re: Formula Help subtracting Percentages

    Thank you for your help. Those formulas worked. I still don't understand how the percentage worked just glad it did.

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,057

    Re: Formula Help subtracting Percentages

    To subtract 20% from x, you times x by 80%, i.e. x*(100% - 20%) or simply x*(1-20%).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-28-2019, 09:23 AM
  2. [SOLVED] Help with subtracting formula
    By tanyamcshane in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2015, 04:48 PM
  3. working across columns finding and then subtracting percentages
    By Mr-Ian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2015, 10:31 PM
  4. [SOLVED] Formula For Subtracting Percentages Needed
    By Node101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2014, 11:41 PM
  5. Reversing input percentages against variable percentages.
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-26-2014, 08:56 PM
  6. Subtracting formula
    By freefallin in forum Excel General
    Replies: 1
    Last Post: 01-18-2011, 08:59 AM
  7. formula for subtracting
    By evilsnugglybunn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2007, 05:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1