+ Reply to Thread
Results 1 to 18 of 18

Salary Bracket returns employees corresponding Contribution for philhealth

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    7

    Salary Bracket returns employees corresponding Contribution for philhealth

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    564

    Re: Salary Bracket returns employees corresponding Contribution for philhealth

    Try this on C2:
    Please Login or Register  to view this content.
    Click (*) if you received helpful response.

    Regards,
    David

  3. #3
    Registered User
    Join Date
    06-17-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    7

    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. #4
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    564

    Re: Salary Bracket returns employees corresponding Contribution for philhealth

    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

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    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.
    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.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  6. #6
    Registered User
    Join Date
    03-11-2014
    Location
    manila,philippines
    MS-Off Ver
    Excel 2010
    Posts
    39

    Unhappy 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.
    Attached Files Attached Files

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    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,
    Vladimir

  8. #8
    Registered User
    Join Date
    09-25-2014
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    1

    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
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-10-2016
    Location
    Manila
    MS-Off Ver
    2007
    Posts
    2

    Re: Salary Bracket returns employees corresponding Contribution for philhealth

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

  10. #10
    Registered User
    Join Date
    08-17-2016
    Location
    Manila, Philippines
    MS-Off Ver
    2013
    Posts
    1

    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. #11
    Registered User
    Join Date
    06-20-2017
    Location
    Cavite
    MS-Off Ver
    2010
    Posts
    2

    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. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,391

    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.

    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.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  13. #13
    Registered User
    Join Date
    06-20-2017
    Location
    Cavite
    MS-Off Ver
    2010
    Posts
    2

    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.
    Last edited by eusebiorobin; 06-20-2017 at 03:21 AM.

  14. #14
    Registered User
    Join Date
    06-20-2017
    Location
    Asia
    MS-Off Ver
    MS Office 2013
    Posts
    1

    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. #15
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,749

    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.

    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.

  16. #16
    Registered User
    Join Date
    02-14-2018
    Location
    Makati, Philippines
    MS-Off Ver
    2007
    Posts
    1

    Thumbs up Re: Salary Bracket returns employees corresponding Contribution for philhealth

    Quote Originally Posted by SDCh View Post
    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.

  17. #17
    Registered User
    Join Date
    01-29-2020
    Location
    Philippines
    MS-Off Ver
    MS 2010
    Posts
    1

    Re: Salary Bracket returns employees corresponding Contribution for philhealth

    same problem..need your help

  18. #18
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,391

    Re: Salary Bracket returns employees corresponding Contribution for philhealth

    Quote Originally Posted by cdm2004830 View Post
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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