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