# Thread: Is this possible with Formula - Increase Matrix

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

2. Hi Excel Experts,

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

Regards
Baiju

3. Originally Posted by Baiju G Nath
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

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

Steve

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•