+ Reply to Thread
Results 1 to 4 of 4

Finding the percentage

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    Murrieta
    MS-Off Ver
    Excel 2007
    Posts
    18

    Finding the percentage

    I have a problem I need help on. I have four different amounts, lets say 10000, 20000,25000, 65000. From those for amounts I want to take a percentage to total $3000. Can someone help me out? Appreciate it.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Finding the percentage

    I do not understand what you are asking?

    If you want to know what percentage of the total($10000, $20000,$25000, $65000) equals $3000, then the answer is
    100*3000/(10000+20000+25000+65000)=2.5%

  3. #3
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Finding the percentage

    =3000/(10000+ 20000+25000+ 65000) = 0.025

    Times that number by each of the numbers 10000, 20000,25000, 65000.

    Gives you:

    250 500 625 1625

    Percentage 3000.xls
    Last edited by darknation144; 03-19-2012 at 11:46 AM.

  4. #4
    Registered User
    Join Date
    11-04-2010
    Location
    Murrieta
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Finding the percentage

    I gotta go back to high school.. Appreciate both of your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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