Salary Bracket returns employees corresponding Contribution for philhealth

**cmaesi** · 06-17-2013, 10:33 PM

Hi everyone! i've got a pretty mindboggling task ahead of me and i want to ask for your help.

I have this table which has employees names with basic pay and contribution.
I was tasked to create a excel sheet where in if the employees basic pay is input, the corresponding contribution for the employee will show depending on which salary bracket he/she is on.

Im not allowed to know what my workmates salaries are since im just an associate, so i just have to leave em blank and wait for my manager to input their salary.

please help me. im running out of ideas. please see attached file for the workbook

**arlu1201** · 06-18-2013, 01:09 AM

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

**cmaesi** · 06-18-2013, 01:10 AM

=VLOOKUP(B2,B7:D35,3,1)

YES SIR! sorry for that.

**arlu1201** · 06-18-2013, 11:52 AM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.