Question about my if statement

Closed
Derrall Posts 6 Registration date Thursday 10 April 2014 Status Member Last seen 1 July 2014 - 1 Jul 2014 à 13:17
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 1 Jul 2014 à 15:12
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 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
1 Jul 2014 à 15:12
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