Multiple IF-AND Statements in an Equation -- Having Trouble Adding a Simple IF Statement to It

[Carrie2525]

I have this lengthy equation that is just a bunch of IF-AND statements that are pieced together. The equations all work, individually (I tested.) The long equation also works until I try to add this last condition that is just a simple IF statement. I'm sure I'm just messing up a parenthesis, or something minor, but I cannot get it to work. So frustrating to be this close and still miss.

Here are all of the equations I need to piece together:

=IF(AND(O7-(O19-29)<91,O17="I"),O19+90)
=IF(AND(O7-(O19-29)>90,O7-(O19-29)<180,O17="I"),O19+179)
=IF(AND(O7-(O19-29)>179,O17="I"),"Indefinite")
=IF(AND(O7-(O19-44)<91,O17="E"),O19+90)
=IF(AND(O7-(O19-44)>90,O7-(O19-44)<180,O17="E"),O19+179)
=IF(AND(O7-(O19-44)>179,O17="E"),"Indefinite")
=IF(O15="N","N/A")

Here is the long formula that works, minus that last (only) IF statement:

=IF(AND(O7-(O19-44)>179,O17="E"),"Indefinite",IF(AND(O7-(O19-44)>90,O7-(O19-44)<180,O17="E"),O19+179,IF(AND(O7-(O19-44)<91,O17="E"),O19+90,IF(AND(O7-(O19-29)>179,O17="I"),"Indefinite",IF(AND(O7-(O19-29)>90,O7-(O19-29)<180,O17="I"),O19+179,IF(AND(O7-(O19-29)<91,O17="I"),O19+90))))))

To clarify, these 7 equations have covered every scenario--there are no other options. Also, each equation is exclusive--only one can be TRUE at a time.

I sincerely appreciate any help you can offer.

Thanks,

Carrie

 

[Carrie2525]

I can't thank you enough for that little trick. BLESS YOU!! I finally figured out how to do it, and it worked perfectly! I am a very happy bunny

 

[MarcelBeug]

You're welcome!