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.
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.
