employer

I need a formula that calculates the companies matching of 401K contributions. The company will auto enroll everyone at 2% unless they opt out and match $0.25 of every $1.00 up to $500 max per year. Lets say I have a participant who made $100,000 and contributed $15,000 to the plan, I'm not...

I need to find out if a specific code appears on a separate worksheet ([Ex_SG_001_consolidated Employer data - version 1 - 06-06-2017.xlsx]Post 05 Liquidations'!$A$3) and if it does I want it to return the data that's in cell K6 that I'm currently working on. If its not on the Employer data...

I created a auto-calculate spreadsheet to display Employer contribution % for both employees and dependents (enter % in specific cell). To account for the many combinations of 0%-100%, I have tried to encompass the following combinations in a nested IF(AND statement. I am looking to put...

I am listing information about people that go into work from a course they are on. Each person has a start date, completion date, job start date and employer name. All of this information is on Sheet 1, Sheet two is used for listing each employer with how many people have started with them. How...

Dear all, I am working on the overlapping working time period, I manage to find out the number of days, months periods of overlapping but I need some help for identify the exactly those period,eliminate them and automatically replace with the the new date after that overlapping periods. The...