Salary Bracket returns employees corresponding Contribution for philhealth

**cmaesi** · 06-17-2013, 10:34 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

**SDCh** · 06-17-2013, 10:40 PM

Try this on C2:

Please Login or Register  to view this content.

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

WHOOAAAA! it actually worked!! hahahaha. Thanks alot! i've been having a hard time trying to figure ooout this one!!!

**SDCh** · 06-17-2013, 10:45 PM

You are welcome.

If your problem is solved, please mark the thread as SOLVED >>Above your first post>>Thread Tools>> Mark your thread as Solved

**vlady** · 06-18-2013, 01:11 AM

Welcome to the forum.
just to add this formula which doesn't need the table anymore.
from your sample file

=ROUNDDOWN(B2,-3)*0.025/2)

included if salary is below 7000 (if there is possibility )
IF(B2<7000,"not applicable",ROUNDDOWN(B2,-3)*0.025/2)

included max in case the salary is over the limit just get the max philhealth deduction

=MAX(IF(B2<7000,"not applicable",ROUNDDOWN(B2,-3)*0.025/2),875) -> finished formula

try it.

**ECYOJ** · 03-11-2014, 02:49 AM

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.

**vlady** · 03-11-2014, 02:54 AM

Welcome to the forum ECYOJ or joyce.

You have to create your own thread for this. it's the the forum rules.

Regards,
Vladimir

**Kristine Camille** · 09-25-2014, 04:15 AM

Hi,

im just wondering if you can help me on what formula did the maker of this excel file used in calculating SSS Employer and Employee Share.

Hope you could help me on this.

Thank you very much

**moriok** · 08-10-2016, 10:55 PM

hi there guys! this actually helped. thanks and more power to all...

**mai08** · 08-17-2016, 03:01 AM

Hi, I'm new on this forum and thanks a lot that this solved my problem too!

**eusebiorobin** · 06-20-2017, 02:50 AM

If the monthly rate is 12911 the result did not match in between the monthly salary range from and monthly salary range to

**FDibbins** · 06-20-2017, 03:03 AM

eusebiorobin welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**eusebiorobin** · 06-20-2017, 03:07 AM

sorry I try this formula =VLOOKUP(B2,B7:D35,3,1) based on this thread

but when the monthly salary is 12911 it does not gave the exact sss contribution.

**Coffee Please** · 06-20-2017, 04:35 AM

Dear Excel Forum,

Do you have the nested if formula for Phil.Health? Given that the amount falls inside the range?

Thank you!

**JohnTopley** · 06-20-2017, 04:40 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Nor does your post make any sense.

Note: the original post is 4 years old.

**ckgajunia** · 02-14-2018, 05:15 AM

Originally Posted by SDCh

Try this on C2:

Please Login or Register  to view this content.

OMAYGASH! THIS IS THE BEST EVER! I've been going nuts with trying a very looooong series of IF Formula to no avail.

**cdm2004830** · 01-29-2020, 06:53 AM

same problem..need your help

**FDibbins** · 01-30-2020, 01:09 AM

Originally Posted by cdm2004830

same problem..need your help

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

**kingadamkeith** · 01-27-2022, 04:09 AM

Hello,

May i request for a new one with updated 2022 contribution table.

Or maybe you can share the password to unprotect the sheet.

Thank you in Advance

**AliGW** · 01-27-2022, 04:11 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

**FDibbins** · 01-27-2022, 09:51 PM

wow this thread contains 3 (now 4) warnings to not post questions on someone else's thread (start your own), and still people keep posting here...cant you read???

Salary Bracket returns employees corresponding Contribution for philhealth

LinkBack

Thread Tools

Display

Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Re: Salary Bracket returns employees corresponding Contribution for philhealth

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions