I am trying to define Branches by State, example would be branches 1,2,3 are in Minnesota and branches 4,5,6 are in Iowa. So, I defined them to the corresponding state to use for my IF statement. However, when I put the defined group into my formula nothing comes back unless that C column is blank. Is there a way to make these groups work or should I try to think of different way to get my state per branch.
=IF(C4=Minnesota_BRs,"MINNESOTA","")
Aucun commentaire:
Enregistrer un commentaire