Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JK
 
Posts: n/a
Default Help! 401k match formula

I am newer to Excel.

I need to create a formula that calculates an employer match and can be
modified to illustrate different employer matching amounts. It will need to
recognize what an employee is contributing, and match the appropriate amount
without going over.

I have two data columns, salary and percentage of salary employee is
deferring.
  #2   Report Post  
 
Posts: n/a
Default

Step One i would take would be to name your columns using the
Insert/Name/Define from the main tool bar. I would label them as
EMPLOYEE, SALARY and DEFER (you will want the defer column formated as
a %).

Step Two would be to name a cell outside of the data area as LIMIT.

Based on the above names, you could put the following formula in the
next column (name this column (again, using the Insert/Name/Define from
above) asMatch) for each row in the database:

=if(DEFER<=LIMIT,DEFER,LIMIT)

If you want the spreadsheet to then calculate the match in the next
column, you would use the formula:
=Salary*Match (this column you may want to name as USD_Match).

HTH

Chris Rogers

  #3   Report Post  
Chris Rogers
 
Posts: n/a
Default

LIMIT is the amount your company is matching up to.

  #4   Report Post  
JK
 
Posts: n/a
Default

Thank you Chris!!!

" wrote:

Step One i would take would be to name your columns using the
Insert/Name/Define from the main tool bar. I would label them as
EMPLOYEE, SALARY and DEFER (you will want the defer column formated as
a %).

Step Two would be to name a cell outside of the data area as LIMIT.

Based on the above names, you could put the following formula in the
next column (name this column (again, using the Insert/Name/Define from
above) asMatch) for each row in the database:

=if(DEFER<=LIMIT,DEFER,LIMIT)

If you want the spreadsheet to then calculate the match in the next
column, you would use the formula:
=Salary*Match (this column you may want to name as USD_Match).

HTH

Chris Rogers


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need help with Index, Match and Countif in the same complicated formula HGood Excel Discussion (Misc queries) 0 February 3rd 05 06:34 PM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM
Offset & Match Formula Shows Duplicates Joe Gieder Excel Worksheet Functions 14 December 7th 04 06:35 PM
how to build a formula to match numbers in 2 columns with the equ. mcdilash Excel Worksheet Functions 1 November 10th 04 06:31 PM
Find a match that;s not exact Phyllis Excel Worksheet Functions 0 November 8th 04 09:12 PM


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"