mercredi 4 décembre 2019

Defined Names in an If then statement

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