Multiply number by percentage

[RoTrKO]

Hello everyone,

I have a quick question about multiplying a number by percentage knowing that the source number is only 33% of the real number.

For example:

11 is the source (which is only 33% of the real number) I want to increase this by 10% which should be 43% of the real number. I have tried the following but it only increase the usual number 11 by 10%.

=11*(1+0.1)

Example given above is only a short example of the initial formula which is a bit complicated as I have a RAWData of inbound calls (which is only 33% of the initial data) from where I use countifs to get hourly incoming.

I hope its clear to everyone.

Thanks,
Chris

[MrShorty]

I'm not sure it is clear to me, but it seems like it should, first, be an algebra problem. Once the algebra is done, the programming should be easy.

11=0.33*x, we could easily solve for x
y=0.44*x. I am not sure why this is how you are defining a "10% increase", but, as long as you know where the 0.44 comes from, it shouldn't matter.

Substitute the expression for x derived in the 1st equation into the 2nd equation, and you should have your expression for y, which you should be able to easily program into Excel.

[6StringJazzer]

If 11 is the source, and is 33% of the real number, then the real number is 33.33... If you want a result that is 44% of 33.33.... then you want 14.66... 14.66.... /11 = 1.33...


So

=11*(1+1/3)

I have no idea where you are getting 10% from.

[oeldere]

11 33% 33,33333333 10% 3,333333333 36,66666667

11/33% = 33.333 is the Original data

increase of 10% of the Original data is 10% * 33.333 = 3,33

The new data is then 33.33 + 3.33 =36.67

[popipipo]

Please upload a excel file because I don't understand what you want.
33%+10% is 43% and not 44%

[RoTrKO]

Thank you everyone for the answers but seems like I couldn't express myself enough to make it understandable.

@popipipo, Sorry that was my mistake, mistypo

Attached you may find demo, A1 is multiplying the numbers C5:I28.

[oeldere]

OK, so you can change the value in cell A1 and the rest will change.

What is your real question?

On what part of the data / calculation do you want help.

[RoTrKO]

OK, so you can change the value in cell A1 and the rest will change.

What is your real question?

On what part of the data / calculation do you want help.

When I apply the 10% increase for C5:I28, should increase it to 43% out of 100% (taking into consideration that the data I have is only 33% of 100%)

[MrShorty]

It seems like it should be 11*(0.33+0.1)/0.33 or 11*(1+0.1/0.33) which is about 14.3. Is that right?

[JohnTopley]

Post #3 explains the maths: the 10% is applied correctly as per your first post

=11*(1+0.1)

[loginjmor]

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?

[RoTrKO]

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

[loginjmor]

Hm. Not sure I understand what you are trying to achieve. Can you post a sample spreadsheet with some data and an example or two of the outcomes you are looking for?

[RoTrKO]

Hm. Not sure I understand what you are trying to achieve. Can you post a sample spreadsheet with some data and an example or two of the outcomes you are looking for?

You may find attached another Demo with explanation of what exactly I want. Basically, with the formula I have made when I apply 10% on A1 the summary goes up to 9249 but I want it to be 11209 which is the actual 43% out of 100% of the data.

As I have only 33% adding the 10% or any other value will only multiply the 33% (formula considers this data as 100%) and makes additional 10% to 8602.

I hope this makes sens

[popipipo]

maybe this simple solution will help you

[loginjmor]

OK - I think part of the problem is there was an error in your formula.

=COUNTIFS(RAWData!$P:$P,C$3,RAWData!$Q:$Q,HOUR($B5),RAWData!$R:$R,$B$3)*(1+$A$1)/C$4

I added the HOUR function as the above formula had difficulty comparing the times and I changed the cell reference from $A$5 to $B5 because $a$5 is a blank cell and Column B has your times in it. Then I copied it across and down.

After making that change, if you enter 30.3% into cell A1, you get the number you were looking for (11,209). I have attached a copy of your workbook with the above changes made. Is that what you were looking for?

[6StringJazzer]

You may find attached another Demo with explanation of what exactly I want. Basically, with the formula I have made when I apply 10% on A1 the summary goes up to 9249 but I want it to be 11209 which is the actual 43% out of 100% of the data.

As I have only 33% adding the 10% or any other value will only multiply the 33% (formula considers this data as 100%) and makes additional 10% to 8602.

I hope this makes sens

I'm sorry but your file does not explain exactly what you want.

You are correct that if 8,602 is 33% of X, then 43% of X should be 11,209. But why do you think the Summary calculated in I30 has anything to do with that? Your 8602 is just typed into E37. Where did you get that from? Why do you think it is 33% of anything?

[RoTrKO]

OK - I think part of the problem is there was an error in your formula.

=COUNTIFS(RAWData!$P:$P,C$3,RAWData!$Q:$Q,HOUR($B5),RAWData!$R:$R,$B$3)*(1+$A$1)/C$4

I added the HOUR function as the above formula had difficulty comparing the times and I changed the cell reference from $A$5 to $B5 because $a$5 is a blank cell and Column B has your times in it. Then I copied it across and down.

After making that change, if you enter 30.3% into cell A1, you get the number you were looking for (11,209). I have attached a copy of your workbook with the above changes made. Is that what you were looking for?

This was partial of what I was looking for and with small modifications I got what I was looking for

Thanks a lot!

[loginjmor]

OK - Thanks for the bump!