I may have figured it out by just marrying up the sequences that would most likely be possible. I started with on expression that worked and then trial/error the functions that I needed to insert to make it work with the next option and then on down the line. Iâ€™m not sure if there is an easier or more concise way of formatting the formulation, but this is what it looks like:

=if(OR(AQ43=â€śResearch reviewâ€ť),"-1",if(OR(BA43=â€śNoâ€ť),"-99",if(AND(BA43="",AQ43=â€śInitial research providedâ€ť),â€ś0â€ť,if(AND(BA43="",AQ43=â€śIdentity confirmedâ€ť),â€ś1â€ť,if(AND(BA43="",AQ43=â€śTelephone and/or email contact madeâ€ť),â€ś2â€ť,if(AND(BA43="",AQ43=â€śPersonal meeting/presentationâ€ť),â€ś3â€ť,if(AND(BA43="",AQ43=â€śVerbal acknowledgementâ€ť),â€ś4â€ť,if(AND(BA43="",AQ43=â€śExecuted agreementâ€ť),â€ś5â€ť,if(AND(BA43="",AQ43=â€śOn marketâ€ť),â€ś6â€ť,if(AND(BA43="",AQ43=â€śUnder contractâ€ť),â€ś7â€ť,if(AND(BA43="",AQ43=â€śClosedâ€ť),â€ś8â€ť,if(AND(BA43="",AQ43=â€śActive repeat clientâ€ť),â€ś9â€ť,if(AND(BA43="",AQ43=â€śMulti-transaction clientâ€ť),â€ś10â€ť,if(AND(BA43="",AQ43=â€śResearch reviewâ€ť),"-1",if(AND(BA43=â€śYesâ€ť,AQ43=â€śInitial research providedâ€ť),â€ś0â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śIdentity confirmedâ€ť),â€ś1â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śTelephone and/or email contact madeâ€ť),â€ś2â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śPersonal meeting/presentationâ€ť),â€ś3â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śVerbal acknowledgementâ€ť),â€ś4â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śExecuted agreementâ€ť),â€ś5â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śOn marketâ€ť),â€ś6â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śUnder contractâ€ť),â€ś7â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śClosedâ€ť),â€ś8â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śActive repeat clientâ€ť),â€ś9â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śMulti-transaction clientâ€ť),â€ś10â€ť,if(AND(BA43=â€śYesâ€ť,AQ43=â€śResearch reviewâ€ť),"-1",if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śInitial research providedâ€ť),â€ś0â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śIdentity confirmedâ€ť),â€ś1â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śTelephone and/or email contact madeâ€ť),â€ś2â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śPersonal meeting/presentationâ€ť),â€ś3â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śVerbal acknowledgementâ€ť),â€ś4â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śExecuted agreementâ€ť),â€ś5â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śOn marketâ€ť),â€ś6â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śUnder contractâ€ť),â€ś7â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śClosedâ€ť),â€ś8â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śActive repeat clientâ€ť),â€ś9â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śMulti-transaction clientâ€ť),â€ś10â€ť,if(AND(BA43=â€śUnknownâ€ť,AQ43=â€śResearch reviewâ€ť),"-1"))))))))))))))))))))))))))))))))))))))