Salary Bracket returns employees corresponding Contribution for philhealth

1. Salary Bracket returns employees corresponding Contribution for philhealth

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.

2. Re: Salary Bracket returns employees corresponding Contribution for philhealth

Try this on C2:
``Please Login or Register  to view this content.``

3. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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

4. Re: Salary Bracket returns employees corresponding Contribution for philhealth

You are welcome.

5. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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

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

6. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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.

7. Re: Salary Bracket returns employees corresponding Contribution for philhealth

Welcome to the forum ECYOJ or joyce.

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

Regards,

8. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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

9. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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

10. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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

11. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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

12. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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.

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.

13. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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.

14. Re: Salary Bracket returns employees corresponding Contribution for philhealth

Dear Excel Forum,

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

Thank you!

15. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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.

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.

16. Re: Salary Bracket returns employees corresponding Contribution for philhealth

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.

18. Re: Salary Bracket returns employees corresponding Contribution for philhealth

Originally Posted by cdm2004830

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.

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

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