# Salary Bracket returns employees AND EMPLOYER corresponding Contribution for sss

1. ## Salary Bracket returns employees AND EMPLOYER corresponding Contribution for sss

Please help me! I need to get the how much will be the contribution of EMPLOYER AND EMPLOYEE depending on his/her salary. Thank you please kindly help me.

3. ## Re: Salary Bracket returns employees AND EMPLOYER corresponding Contribution for sss

Hello and Welcome to the forum

copy paste below in C2
=INDEX(D\$8:D\$20,MATCH(\$B2,\$B\$8:\$B\$20))
drag down and drag to right

4. ## Re: Salary Bracket returns employees AND EMPLOYER corresponding Contribution for sss

Hi
Paste this formula to c2 cell and drag to right and down
=VLOOKUP(\$B2,\$B\$8:\$E\$20,MATCH(C\$1,\$B\$7:\$E\$7,0))

To Unite both criterias (employee and employer) I changed column names to original

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1