+ Reply to Thread
Results 1 to 2 of 2

Really driving me mad now. I need to use multiple percentages please help

  1. #1
    Registered User
    Join Date
    02-08-2016
    Location
    uk
    MS-Off Ver
    2013
    Posts
    1

    Really driving me mad now. I need to use multiple percentages please help

    I need to find the way to do a percentage - a percentage - a percentage
    my example is 100 - 40% - 10 % - 10 %
    So the answers I am looking for are
    100 - 40 % = 60 then minus 10% which would equal 54 then minus another 10% that would get final total to 48.6
    so 100 - 40% = 60 then
    60 minus 10% = 6 but then thats taken away from 60 to make 54
    then finally 54 - 10% = 5.4 which then taken away from 54 equals 48.6
    Please help

    thanks

  2. #2
    Registered User
    Join Date
    06-01-2013
    Location
    Northampton, England
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Really driving me mad now. I need to use multiple percentages please help

    Hi

    Try =((100-(100*0.4))*0.9)*0.9

    or if you have 100 in cell A1, try entering =((A1-(A1*0.4))*0.9)*0.9 in cell B1

    Regards
    Alan

+ 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: 13
    Last Post: 12-22-2015, 05:21 AM
  2. Multiple values driving a single result
    By Comptechrx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2015, 10:06 AM
  3. [SOLVED] Multiple if with percentages
    By Kwoznica in forum Excel General
    Replies: 15
    Last Post: 12-28-2012, 04:49 AM
  4. Multiple IF function (driving me CRAZY)
    By johnstonJr in forum Excel General
    Replies: 9
    Last Post: 07-10-2012, 05:56 PM
  5. Excel 2007 : Multiple line graph driving me CRAZY
    By nathank1980 in forum Excel General
    Replies: 5
    Last Post: 04-27-2012, 11:28 AM
  6. multiple formula driving me crazy
    By DannyCog in forum Excel General
    Replies: 1
    Last Post: 10-14-2009, 05:19 AM
  7. Multiple Macros Driving Me Loco!!!
    By gandolff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2009, 07:56 AM

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