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
[TABLE="width: 415"]
<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>[TR]
[TD="class: xl64, width: 154, bgcolor: transparent"]NAME[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]RANK[/TD]
[TD="class: xl65, width: 69, bgcolor: transparent"]BASD[/TD]
[TD="class: xl65, width: 50, bgcolor: transparent"]TIS[/TD]
[TD="class: xl66, width: 68, bgcolor: transparent"]DOR[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]TIG[/TD]
[TD="class: xl66, width: 82, bgcolor: transparent"]ZONE[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]FOX[/TD]
[TD="class: xl70, bgcolor: transparent"]SPC[/TD]
[TD="class: xl71, bgcolor: transparent"]2-Feb-14[/TD]
[TD="class: xl70, bgcolor: transparent"]46[/TD]
[TD="class: xl71, bgcolor: transparent"]1-Jul-16[/TD]
[TD="class: xl70, bgcolor: transparent"]17[/TD]
[TD="class: xl72, bgcolor: transparent"]PRIMARY[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]ANDERSON[/TD]
[TD="class: xl67, bgcolor: transparent"]SPC[/TD]
[TD="class: xl68, bgcolor: transparent"]6-Oct-14[/TD]
[TD="class: xl70, bgcolor: transparent"]38[/TD]
[TD="class: xl68, bgcolor: transparent"]1-Jul-16[/TD]
[TD="class: xl70, bgcolor: transparent"]17[/TD]
[TD="class: xl72, bgcolor: transparent"]PRIMARY[/TD]
[/TR]
</tbody>[/TABLE]
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
TIS	TIG	ZONE
UNDEFINED
MIL
SECONDARY
PRIMARY

<tbody>
[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]7[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]23[/TD]

</tbody>

Sheet2​

And with that I came to this

	A	B	C	D	E	F	G	H
NAME	RANK	BASD	TIS	DOR	TIG	ZONE	New ZONE
FOX	SPC	PRIMARY	PRIMARY
ANDERSON	SPC	PRIMARY	PRIMARY

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]########[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]01-Jul-16[/TD]
[TD="align: right"]17[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]06-Oct-14[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]01-Jul-16[/TD]
[TD="align: right"]17[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G2[/TH]
[TD="align: left"]=IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),"PRIMARY","SECONDARY"),"UNDEFINED")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H2[/TH]
[TD="align: left"]=CHOOSE(1+((D2>=17)*(F2>=5))+((D2>=35)*(F2>=7))+((D2>=47)*(F2>=23)), "UNDEFINED", "MIL", "PRIMARY", "SECONDARY")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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

[TABLE="width: 415"]
<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>[TR]
[TD="class: xl68, width: 154, bgcolor: transparent"]CAUBLE[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]SPC[/TD]
[TD="class: xl65, width: 69, bgcolor: transparent"]6-Apr-15[/TD]
[TD="class: xl66, width: 50, bgcolor: transparent"]32[/TD]
[TD="class: xl65, width: 68, bgcolor: transparent"]1-Dec-16[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]12[/TD]
[TD="class: xl67, width: 82, bgcolor: transparent"]SECONDARY[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]CHRISTOPHER[/TD]
[TD="class: xl64, bgcolor: transparent"]SPC[/TD]
[TD="class: xl65, bgcolor: transparent"]9-Sep-14[/TD]
[TD="class: xl66, bgcolor: transparent"]39[/TD]
[TD="class: xl65, bgcolor: transparent"]9-Sep-16[/TD]
[TD="class: xl66, bgcolor: transparent"]15[/TD]
[TD="class: xl67, bgcolor: transparent"]PRIMARY[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]DEGUST[/TD]
[TD="class: xl64, bgcolor: transparent"]SPC[/TD]
[TD="class: xl65, bgcolor: transparent"]5-Feb-13[/TD]
[TD="class: xl66, bgcolor: transparent"]58[/TD]
[TD="class: xl65, bgcolor: transparent"]1-Oct-14[/TD]
[TD="class: xl66, bgcolor: transparent"]38[/TD]
[TD="class: xl67, bgcolor: transparent"]PRIMARY[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]DETMERS[/TD]
[TD="class: xl64, bgcolor: transparent"]SPC[/TD]
[TD="class: xl65, bgcolor: transparent"]10-Aug-16[/TD]
[TD="class: xl66, bgcolor: transparent"]16[/TD]
[TD="class: xl65, bgcolor: transparent"]1-Apr-17[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl67, bgcolor: transparent"]UNDEFINED[/TD]
[/TR]
</tbody>[/TABLE]

 

[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