Skip to Content
0
Former Member
Sep 23, 2008 at 07:39 PM

IF THEN Formula

83 Views

I have a list of 17,000 customer codes which all belong to one of 20 or so representatives. I am building a report that would break down by salesperson, what shipped out the previous day. Problem is the tables contain no salesperson information.

What I need to do is create a formula based on the customer number, but I'm not sure how to do this.

Basically I need it to be something like....

IF {SHIPHIST.CUST_NUM} = 1,2,3,4,5,6,7,8,9,10 OR 11 THEN "Salesperson 1"

ELSE IF {SHIPHIST.CUST_NUM} = 12,13,14,15,16 OR 17 THEN "Salesperson 2"

ELSE "Salesperson 3"

Is this possible?