+ Reply to Thread
Results 1 to 19 of 19

Multiply number by percentage

Hybrid View

  1. #1
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Multiply number by percentage

    Hi -

    Might as well throw my $0.02 in.

    I'm not sure which way you are trying to work this problem, so I will work it both ways:

    0.33x = 11

    Which means X is 33.33 as everyone agrees. But to maintain balance to the equation, you have to multiply both sides by 1.1 (or a 10% increase) which gives you:

    1.1 * 0.33x = 11 * 1.1
    or
    0.363x = 12.1 which still equates to x = 33.33 so our formula is still valid and balanced.

    I think the problem is SAYING 10% takes you from 33% to 43%, which isn't true. You can't add the two percentages. You have to multiply. So you should end up with 36.3%, not 43%.

    Working the problem the other way: IF you WANT the result to BE 43% of the original number, you would have to multiply 11 by 1.3029. I get that by taking 33.33 x 0.43 = 14.3319
    14.3319 / 11 = 1.3029 which is an increase of 30.29%, not 10%.

    Taking percentages of percentages can get really tricky. I have to write them out as I did above.

    Make sense or am I way off base?
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  2. #2
    Registered User
    Join Date
    04-27-2016
    Location
    Romania
    MS-Off Ver
    MS Office 2013
    Posts
    20

    Re: Multiply number by percentage

    Quote Originally Posted by loginjmor View Post
    Hi -

    Might as well throw my $0.02 in.

    I'm not sure which way you are trying to work this problem, so I will work it both ways:

    0.33x = 11

    Which means X is 33.33 as everyone agrees. But to maintain balance to the equation, you have to multiply both sides by 1.1 (or a 10% increase) which gives you:

    1.1 * 0.33x = 11 * 1.1
    or
    0.363x = 12.1 which still equates to x = 33.33 so our formula is still valid and balanced.

    I think the problem is SAYING 10% takes you from 33% to 43%, which isn't true. You can't add the two percentages. You have to multiply. So you should end up with 36.3%, not 43%.

    Working the problem the other way: IF you WANT the result to BE 43% of the original number, you would have to multiply 11 by 1.3029. I get that by taking 33.33 x 0.43 = 14.3319
    14.3319 / 11 = 1.3029 which is an increase of 30.29%, not 10%.

    Taking percentages of percentages can get really tricky. I have to write them out as I did above.

    Make sense or am I way off base?
    You had a great point indeed! The thing is I want to see gradually increasing on inbound calls which means I have to watch out by playing with the increasing percentage to see the gaps of resources etc.

    The 10% was just an example, what exactly I want is to be able to increase gradually from 1-67% to see the changes and also when I hit 67% on A1 to get the 100% of the number(volume).

    I'm still trying to figure out how to make this real
    Last edited by RoTrKO; 04-28-2016 at 04:38 PM.

+ 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. [SOLVED] multiply a range of cells and then subtract a percentage.
    By louis.vail in forum Excel General
    Replies: 7
    Last Post: 08-19-2015, 09:00 AM
  2. Multiply by percentage and round final results
    By jeffreybrown in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-04-2012, 05:51 PM
  3. Replies: 3
    Last Post: 02-01-2012, 04:21 PM
  4. Replies: 6
    Last Post: 01-26-2012, 09:15 PM
  5. Multiply a certain percentage in Excel
    By guiri in forum Excel General
    Replies: 1
    Last Post: 06-07-2007, 09:48 PM
  6. [SOLVED] formula cell value multiply by percentage
    By formula using percentage question in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-01-2006, 09:25 PM
  7. How do I multiply cell value by percentage?
    By Kelly P. in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2005, 03:05 PM

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