# Redistribution of percentages??? I don't know what else to call it

#### lo1ly

##### Board Regular
Hi I'm having a hard time getting me percentages to equal 100.. I'm trying to remove one of the inputs and redistribute that percentage based on the other percentages..

Example: Here i want to remove the 24.22 and distribute that percentage to the other ones based on their value. As of right now Im doing (3.53+(3.53*24.22)) but I'm coming up 10% short of 100 when I do this for the rest of the entries.
 Initial Inputs 3.53% 11.15% 21.76% 29.92% 9.42% 24.22%

<tbody>
</tbody>

Let me know if you need any more additional infromation

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Use 100.0 * 3.53 / (100.0 - 24.22) instead.

 Row\Col A​ B​ C​ D​ 1​ Input​ Remove​ Output​ 2​ 3.53%​ ​ 4.66%​ C2: =IF(B2<>"", 0, A2/\$A\$9) 3​ 11.15%​ ​ 14.71%​ 4​ 21.76%​ ​ 28.71%​ 5​ 29.92%​ ​ 39.48%​ 6​ 9.42%​ ​ 12.43%​ 7​ 24.22%​ x​ 0.00%​ 8​ 9​ 75.78%​ A9: =SUMIF(B2:B7, "", A2:A7)

 Row\Col A​ B​ C​ D​ 1​ Input​ Remove​ Output​ 2​ 3.53%​ 4.66%​ C2: =IF(B2<>"", 0, A2/\$A\$9) 3​ 11.15%​ 14.71%​ 4​ 21.76%​ 28.71%​ 5​ 29.92%​ 39.48%​ 6​ 9.42%​ 12.43%​ 7​ 24.22%​ x​ 0.00%​ 8​ 9​ 75.78%​ A9: =SUMIF(B2:B7, "", A2:A7)

<tbody>
</tbody>
Use 100.0 * 3.53 / (100.0 - 24.22) instead.

Thank you these both worked great

You're welcome.

 Row\Col A​ B​ C​ D​ 1​ Input​ Remove​ Output​ 2​ 3.53%​ ​ 4.66%​ C2: =IF(B2<>"", 0, A2/\$A\$9) 3​ 11.15%​ ​ 14.71%​ 4​ 21.76%​ ​ 28.71%​ 5​ 29.92%​ ​ 39.48%​ 6​ 9.42%​ ​ 12.43%​ 7​ 24.22%​ x​ 0.00%​ 8​ 9​ 75.78%​ A9: =SUMIF(B2:B7, "", A2:A7)
@shg, I fine the best solution for me

Replies
0
Views
362
Replies
3
Views
556
Replies
3
Views
1K
Replies
1
Views
960
Replies
26
Views
20K

1,196,481
Messages
6,015,451
Members
441,896
Latest member
clomah

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back