Need help urgent!!

[Warhawk]

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.

 

[oldbrewer]

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>

 

[Warhawk]

Yes something like that just reallocating

 

[Warhawk]

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

 

[oldbrewer]

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