formulas

  • Thread starter Thread starter TB5150
  • Start date Start date
T

TB5150

Hi:

I am trying to put the following parameters into a formula based on an
average already calculated in another cell. I tried using the "IF" function,
but the results do not seem to be what I expect.

If the NHCE's are matched 0% to 2%, the HCE's may receive a match two times
more than this.
If the NHCE's are matched 2% to 8%, the HCE's may receive a match 2% more
than this.
If the NHCE's are matched over 8%, the HCE's may receive a match 1.25 times
more than this.

In case it helps, I am trying to duplicate the ADP/ACP tests for 401(k)
plans. We have a program to do this, but I thought it wiuld be nice to have
this as a backup since the program is not 100% reliable.

Any help would be appreciated.

Tom
 
As ALWAYS post your efforts for comments. Using IF the key is to start at
the top

=if(a1>.08,1.5,if(a1>=.02,2 >>>etc
 
Back
Top