Formula help needed; IF or IFS?

Question

AF2, AF6, AF10 and AF16 have several zip codes separated by a comma. I know V2 is listed in AF16 but I keep getting False as the answer. How can I correct this formula? Using 365.

=IF(V2=AF2,"Coastal",IF(V2=AF6,"Zone A",IF(V2=AF10,"Zone B",(IF(V2=AF16,"Zone C")))))

sergeibaklan · Answer

YvetteGarza&nbsp;
In general formula is correct, something is with values. Try in any empty cell =V2=AF16 if it returns TRUE or FALSE

yvettegarza · Answer

SergeiBaklan&nbsp;I have zip codes like this in those cells.&nbsp;77414,77422,77465,77534,77541,77550,77551,77554,77563,77577,77623

sergeibaklan · Answer

YvetteGarza&nbsp;
Perhaps like this

with
=IF(V2="","zip is not defined",
 IF(COUNTIF($AE$2,"*"&amp;V2&amp;"*"),"Coastal",
 IF(COUNTIF($AE$6,"*"&amp;V2&amp;"*"),"Zone A",
 IF(COUNTIF($AE$10,"*"&amp;V2&amp;"*"),"Zone B",
 IF(COUNTIF($AE$16,"*"&amp;V2&amp;"*"),"Zone C",
 "wrong zip"
)))))

yvettegarza · Answer

Nope didn't work. Thanks so much for trying though.

yvettegarza · Answer

SergeiBaklan&nbsp;YAYYYY! Success, I changed the "wrong zip" to "Not Listed" but other than that, your formula worked. Now I need to learn/understand the reasoning behind this so I can retain the thought process.Thank you so much!!

Forum Discussion

Formula help needed; IF or IFS?

6 Replies

Resources