Solved If statement with AND plus the OR function

March 30, 2014 at 08:59:01
Specs: Windows Vista
How would this formula work in an Nested IF Function for Excel 2010?

Column G--Salespeople who have worked for XYZ Security Systems more than seven years and have annual sales of more than $30,000 will be assigned a job classification of 3. An employee meeting either criterion receives a job classification of 2, and an employee meeting no criteria is assigned a job classification of 1.


See More: If statement with AND plus the OR function

Report •

#1
March 30, 2014 at 11:04:16
✔ Best Answer
Since you didn't give us any cell references other than "Column G", all we can offer is a generic suggestion.

I'll use A1 for "Years Of Service" and B1 for "Annual Sales".

=IF(AND(A1>7,B1>30000),3,IF(OR(A1>7,B1>30000),2,1))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question