[Solved] Nesting IF Function not Working

[Pulling37]

Why is my formula not working on the ELSE portion? Thanks for your help.

My Formula is here

[FJCC]

FIND() does not return 0 when it fails to find the text, it returns a #VALUE error, which stops further evaluation of the formula. You can use ISERROR() to catch that. Here are two versions. The first uses NOT(ISERROR(FIND())) to produce the logic you meant with FIND () > 0

Code: Select all

=IF(NOT(ISERROR(FIND("Hastings";B2)));"Hastings";IF(NOT(ISERROR(FIND("Waurika";B2)));"Waurika";""))

The second one drops the NOT(), so the logic is inverted

Code: Select all

=IF(ISERROR(FIND("Hastings";A1));IF(ISERROR(FIND("Waurika";A1));"";"Waurika");"Hastings")

[Pulling37]

OH Thank you so much!! That first one worked for me....now to nest more for more towns.

[RusselB]

Please note that there are limitations as to the number of parameters that you can have in a single IF statement. In this case, the single IF statement is the initial IF.... the subsequent IF's that are contained in the initial IF don't extend the number of parameters, but, realistically do reduce them.
If you are going to have a lot of these, then I suggest you consider making a small table and work with one or more of the lookup functions (eg: VLOOKUP, LOOKUP, MATCH and INDEX come to mind quickly)