Need help urgent!!

Warhawk

New Member
Here's a quick question.

I am currently trying to create a calculator on excel that determines if a cell is greater than 10% then by how much and then allocates the amount that it is greater than to another cell respectively. So I have 3 categories High Medium Low that equate to 100% there are targets and actuals for each.

Lets say targets were 35% Low
35% Med
30% High

Actuals were 0.01% Low
95.9% Med
4.09% High

Because my target for low was so high and I only ended up using 0.01% and not 35% I now want the formula that will look at the low and say ok the target was high I will leave 10% but take that 25% and added to the medium bringing the medium target from 35% to now %60 percent. Does anyone know how to do this.

Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
 Lets say targets were 35% Low 35% Med 30% High Actuals were 0.01% Low 95.9% Med 4.09% High Because my target for low was so high and I only ended up using 0.01% and not 35% I now want the formula that will look at the low and say ok the target was high I will leave 10% but take that 25% and added to the medium bringing the medium target from 35% to now %60 percent. Does anyone know how to do this. act targets is act v low new target amnt removed new medium revised targets low 0.01 0.35 yes 0.1 0.25 0.1 med 95.9 0.35 no 0.6 0.6 high 4.09 0.3 no 0.3 is this what you want helper columns can be hidden if you want the new tasrgets to overwrite the old targets a macro to do this and delete the helper columns would be one way

<colgroup><col span="3"><col><col><col><col span="2"><col><col span="4"></colgroup><tbody>
</tbody>

Yes something like that just reallocating

But it needs to go through each and cannot allocate what has already been allocated should always = 100%

SORRY - cannot help further as I am not clear what you want...

Replies
1
Views
767
Replies
0
Views
298
Replies
1
Views
1K
Replies
6
Views
1K
Replies
6
Views
530

1,203,221
Messages
6,054,224
Members
444,711
Latest member
Stupid Idiot

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.

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