# IF/AND Function (Need a formula)

#### Phoebe8178

##### New Member
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

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Repost and turn HTML OFF

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)))

Replies
1
Views
121
Replies
3
Views
524
Replies
2
Views
371
Replies
0
Views
467
Replies
11
Views
918

1,219,905
Messages
6,150,901
Members
450,991
Latest member
ExcelDoer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back