mercredi 9 novembre 2016

How to have multiple if statements within named range

I am looking to find out how I can write the following if statements within the one line. Unfortunately the IF statements work individually but whenever I combine it, it gives me a #VALUE error.

=IF(A1=OUT,C1,IF(A1=INT,C1,IF(A1=IN,C1,"Not Found")))

OUT, INT and IN are all named ranges within my file and I have worked out the reason why I get the error and I think this is due to the first statement not being true and from what I can see its not moving onto the next part of the formula.

The problem I have is when I reach cell A8, the value in this cell now belongs to the named range INT and this is when the formula shows the #VALUE error.

I would really appreciate it if somebody could please advise where I am going wrong and how I can fix this.

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire