Need Some help. IF formula

[ThedoreHolley]

So I'm trying to do this formula for ARMY promotion times. I need a couple of thinks to happen for this. So I need some date for Secondary, Primary, and MIL.

Secondary zone 17 months TIS, 5 months TIG

Primary zone 35 months TIS, 11 months TIG
Mandatory list integration: 47 months TIS , 23 months TIG

So here is my table

NAME	RANK	BASD	TIS	DOR	TIG	ZONE
FOX	SPC	2-Feb-14	46	1-Jul-16	17	PRIMARY
ANDERSON	SPC	6-Oct-14	38	1-Jul-16	17	PRIMARY

<colgroup><col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="64" style="width: 48pt;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="64" style="width: 48pt;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <tbody> </tbody>

Zone formula I have is =IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),"PRIMARY","SECONDARY"),"UNDEFINED")
trying to have it work for all 3 =IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),),IF(AND(D2>=47,F2>=23)"PRIMARY","SECONDARY", "MIL"),"UNDEFINED")

 

[mrhstn]

I think I understood this, I looked at these 'ZONES'

	N	O	P
2	TIS	TIG	ZONE
3	0	0	UNDEFINED
4	17	5	MIL
5	35	7	SECONDARY
6	47	23	PRIMARY

<tbody>
</tbody>

Sheet2​

And with that I came to this

	A	B	C	D	E	F	G	H
1	NAME	RANK	BASD	TIS	DOR	TIG	ZONE	New ZONE
2	FOX	SPC	########	46	01-Jul-16	17	PRIMARY	PRIMARY
3	ANDERSON	SPC	06-Oct-14	38	01-Jul-16	17	PRIMARY	PRIMARY

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula G2 =IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),"PRIMARY","SECONDARY"),"UNDEFINED") H2 =CHOOSE(1+((D2>=17)*(F2>=5))+((D2>=35)*(F2>=7))+((D2>=47)*(F2>=23)), "UNDEFINED", "MIL", "PRIMARY", "SECONDARY") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[ThedoreHolley]

So I just tried to input that into my table and it's not coming out right. The issue is the person needs both TIS and TIG to be in one of the zones Secondary, Primary and MIL and of course if they don't meet any of them Undefined(not qualified). Don't know if there are to many variables for it to work.
If you see the table below CAUBLE should be Secondary because he doesn't meet the TIS of 35
Christopher is correct for Primary
Degust should be MIL he over the 47 TIS and over TIG 23 but comes up as Primary
Detmers is undefined because does not have 17 TIS

CAUBLE	SPC	6-Apr-15	32	1-Dec-16	12	SECONDARY
CHRISTOPHER	SPC	9-Sep-14	39	9-Sep-16	15	PRIMARY
DEGUST	SPC	5-Feb-13	58	1-Oct-14	38	PRIMARY
DETMERS	SPC	10-Aug-16	16	1-Apr-17	8	UNDEFINED

<colgroup><col width="154" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5632;"> <col width="64" style="width: 48pt;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="64" style="width: 48pt;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <tbody> </tbody>

 

[admiral100]

Hi,

Try this:

=IF(AND(D2>=47,F2>=23),"Mil",IF(AND(D2>=35,F2>=11),"Primary",IF(AND(D2>=17,F2>=5),"SECONDARY","UNDEFINED")))

 

[ThedoreHolley]

I think that works fine thanks