Dfyjkt

up vote 0 down vote favorite I'll be flying frequently between KTM, GVA and the US (primarily IAD/DCA and BOS but possibly some SFO/OAK/SJC) and then also some domestic travel in the US. I'd like to stick with one airline/alliance to optimize point collection and get status. Based on the limited number of airlines that fly to KTM, my airline of choice would be Etihad however their partnerships are pretty weak so I think Qatar Airlines is my go to. As they're in oneworld, I'd be able to fly American Airlines for domestic travel in the states and continue to accumulate points as well. If I go with this scenario, my questions are: Would it be more beneficial to park all of my points in QA or AA? Since I'm a US resident, the benefit of AA is that I could get their credit card to accrue more miles I don't think I can get the QA credit card as I'm not a resident of Qatar I imagine that I'll be doing more flying with QA than AA Based on what I'v

up vote 0 down vote favorite I'm writing an if statement with 5 separate criteria based on whether they are greater than zero. I want 6 separate if statements based on whether 0 criteria >0, 1 criteria > 0 , 2 etc... up to 5 criteria > 0. I was trying to do this with OR and AND statements, but it's obviously not the solution. What I'm essentially after: If 0 Criteria > 0 Then Do this ElseIf 1 Criteria > 0 Then Do this ElseIf 2 Criteria > 0 Then Do this .... ElseIf 5 Criteria > 0 Then Do this End If excel vba excel-vba share | improve this question edited Nov 8 at 16:51 TylerH 15.3k 10 50 67 asked Nov 8 at 15:57 user10451617 22 5 2 So you have 5 independent numeric variables and want a different action depending on how many are 0? – Alex K. Nov 8 at 16:03 1 The criteria, are they cells on a worksheet? Are those cells contiguous? – Scott Craner Nov 8 at 16:11 add a