+ Reply to Thread
Results 1 to 4 of 4

calculate percentage of a percentage

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    Waggaman, LA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Red face calculate percentage of a percentage

    Hi every1

    I need your help calculating the percentage of a percentage and writing the formula for excel.

    There are 295 people in a room, of the 295, 75 or 25% are mothers. (I know how to calculate 25% - 75/295 = 25.42) of the 75 mothers 35 have 3 children, 32 have 2 children and 10 have 1 child.

    This is what I need help with.
    35 is what percent of 25%

    32 is what percent of 25%

    10 is what percent of 25%

    Thanks every1.

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: calculate percentage of a percentage

    Hi,

    I'm afraid your question is not logically meaningful. There is, strictly speaking, no proper answer to "32 is what percent of 25%?". You could just about get away with asking: "32 is what percent of 25% of 295?" but then this becomes simply "32 is what percent of 73.75?" to which the answer is: "43% to 2 significant figures." In general, you can only speak of a percent of a number, not of another percent.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: calculate percentage of a percentage

    As stated earlier you cant really have a percentage of a percentage.
    You should be asking

    This is what I need help with.
    35 is what percent of 75?

    32 is what percent of 75?

    10 is what percent of 75?

    Which is obviously x / 75 * 100
    where x is the first number above
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: calculate percentage of a percentage

    There's nothing magic about percentages.

    35/75, or 46%, of mothers have 3 kids

    35/75 * 75/295 (==35/295), or 12% of the people in the room, are mothers with three kids.
    Entia non sunt multiplicanda sine necessitate

+ 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