formulas
 

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

formulas
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TB5150" wrote in message
...
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