Try this (though I didn't test it out):

=IF(AND(A1<A2,B1=""),"Unit Pick",IF(AND(A1<A2,B1<""),"Case
Pick",IF(AND(A1=A2,ISTEXT(B1)=TRUE,B2=""),"Both types of
Picks","Invalid Combination")))



tom wrote:
In a worksheet I am trying to write an IF statement that will fill-in column
F with the appropriate Picking Style.

Here are the qualifiers:

1) A1 and A2 are not equal and B1 is blank = "Unit Pick".
If A1 and A2 are not equal and B1 is not blank "Case Pick".
If A1 and A2 are equal and B1 has text and B2 is empty "Both types of Picks".



A B C D E F
01201-0083 LR-27-01-01 25.99 3 Unit Pick Only
01201-0084 LQ-16-04-02 22.99 2 Unit Pick Only
01201-0088 1 DISC ARROW S LN-52-04-02 22.99 3 Case Pick
01201-0093 1 BALL BRZ SM LG-49-01-01 79 47 Case Pick
01201-0093 1 BALL BRZ SM LH-62-03-02 79 56 Case Pick
01201-0093 LG-13-04-02 79 23 Both Case and Unit Pick


Thanks for the Help,
Tom