IF/AND Function (Need a formula)

[Phoebe8178]

I am looking for a formula. Here is the information that I need for developing it.
If Salary is less than or equal to $50,000 and employee is at the company under 3 years, than the truth value is 25%.
If Salary is less than or equal to $50,000 and employee is at the company over 3 years, than the truth value is 6.25%
If Salary is greater than $50,000 and is less than or equal to $300,000 and employee is at the company under 3 years, than the truth value is 43.75%.
If Salary is greater than $50,000 and is less than or equal to $300,000 and employee is at the company over 3 years, than the truth value is 25%.

I am somewhat familiar with the if function and idex and matching, but I've never had to compare two types of information in one formula before. Please help. I'm clueless on this one. Thank you!!!
This message was edited by Phoebe8178 on 2002-10-07 11:01
This message was edited by Phoebe8178 on 2002-10-07 11:02
This message was edited by phoebe8178 on 2002-10-07 11:29

 

[lenze]

Repost and turn HTML OFF

 

[Albert 1]

When A1 houses the salary and B1 the number of years:

=IF(OR(AND(A1<=50000,B1<3),AND(A1>50000,A1<=300000,B1>3)),0.25,IF(AND(A1<50000,B1>3),0.0625,IF(A1>300000,"",0.4375)))