I understand nesting IF/AND statements but when my criteria is a list {} I'm not getting the desired results. Is there anyway to correct this without creating a "helper cell"?
=IF(AND(C2="CBHNP",F2="CHAM"),"CBHNP-Franklin Fulton",IF(AND(C2="CBHNP",F2<>"CHAM"),"CBHNP-Capital Region",IF(AND(C2="CCBH",F2={"RPSY","RDG","CSBERKS"}),"CCBH-Berks",IF(AND(C2="CCBH",F2={"YORK","YORK-P","CSYORK"}),"CCBH-YORK",IF(AND(C2="CCBH",F2<>{"YORK","YORK-P","CSYORK","RPSY","RDG","CSBERKS"}),"CCBH-North Central",B2)))))
Aucun commentaire:
Enregistrer un commentaire