Carrie2525
New Member
- Joined
- Jun 10, 2015
- Messages
- 18
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
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