Question about my if statement

Closed
Derrall Posts 6 Registration date Thursday April 10, 2014 Status Member Last seen July 1, 2014 - Jul 1, 2014 at 01:17 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 1, 2014 at 03:12 PM
Hello,

I have an excel file with portions of addresses and i want to take the city state and zip code and put it in a separate cell. For that i use this function

=IF(SEARCH("Auror 60505",C89,1),"AURORA IL, 60505")

And this works fine

Now i want to add an additional if function, and i cant seem to get it work correctly using...

=IF(SEARCH("Auror 60505",C89,1),"AURORA IL, 60505",IF(SEARCH("Auror 60504",C89,1),"AURORA IL, 60504"))

And I have tried it with putting () around the 2nd if function but I am at a loss.


Also, how do i make it so that the code stands out.... i know sometimes using /code or /b

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 1, 2014 at 03:12 PM
Derrall, Good afternoon.

Try to use it:

=IF(SEARCH("Auror 60505",C89,1),"AURORA IL, 60505",IF(SEARCH("Auror 60504",C89,1),"AURORA IL, 60504",""))

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0