IF/AND Function (Need a formula)

Phoebe8178

New Member
Joined
Sep 22, 2002
Messages
17
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Albert 1

Active Member
Joined
Feb 22, 2002
Messages
393
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)))
 

Forum statistics

Threads
1,144,049
Messages
5,722,227
Members
422,417
Latest member
Johhny

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top