IF Formula

[ThedoreHolley]

I'm trying to do a If formula for ARMY Promotions.

[TABLE="width: 522"]
<tbody>[TR]
[TD]NAME[/TD]
[TD]RANK[/TD]
[TD]BASD[/TD]
[TD]TIS[/TD]
[TD]DOR[/TD]
[TD]TIG[/TD]
[TD]ZONE[/TD]
[TD="align: right"]7-Oct-17[/TD]
[/TR]
[TR]
[TD]FOX[/TD]
[TD]SPC[/TD]
[TD]2-Feb-14[/TD]
[TD]44[/TD]
[TD]1-Jul-16[/TD]
[TD]15[/TD]
[TD]FALSE[/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="3"><col><col span="2"><col><col></colgroup>[/TABLE]


This is what I'm starting with I need the zone Colum to give me Primary or secondary.

=IF((AND(D2>=17,D2<34, F2>=5,<6)), "SECONDARY")=IF((AND(D2>=35, F2>=7)), "PRIMARY")


Basically need secondary between 17-34 TIS and between 5-6 TIG then that's secondary
Primary 35 and above TIS and 7 above TIS.

Any help

 

[Tetra201]

Try

=IF(AND(D2>=17,F2>=5),IF(AND(D2>=35,F2>=7),"PRIMARY","SECONDARY"),"UNDEFINED")

 

[ThedoreHolley]

I Think it works. Thanks