Is this possible with Formula – Increase Matrix

Topic

New Reply

Hi Excel Experts,

I am working on a increase % matrix for my employee. I have attached an excel that would help.

I have the employees spread in 5 bands RPO1,RPO2,RPO3,RPO4,RPO5
The employee fall with a specific salary range
10.00% – 84.99%
85.00% – 94.99%
95.00% – 104.99%
105.00% – 114.99%
115.00%+

– I have the % spread of employee in this range entered manually i.e. column K
Column I has the desired % spread of employee in the 5 bands mentioned above
Target % Increase is in Column.

Is it possible through a formula in the cells shaded GREY Column E-G to arrive at the Target %’s in Column L. At the moment im doing it manually to somehow get it close to the Target

Hope to have a positive response. This is save a lot of my time/effort to arrive at the Target manually

Regards
Baiju

Reply | Quote

Replies

Hi Excel Experts,

I havent heard any solutions for this, is this possible with a formula.

Regards
Baiju

Reply | Quote

Hi Excel Experts,

I havent heard any solutions for this, is this possible with a formula.

Regards
Baiju

Baiju

You may want to have a look at this post in the WS Lounge

Reply | Quote

No formula solution, but since you cross-posted, there is a solution posted here

Steve

Reply | Quote

Can you explain through example what you’re trying to accomplish? I think I’m just a little thick-headed this morning.

Reply | Quote