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
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 1 Jul 2014 à 15:12
Related:
- 60505 zip code
- More than 1 if statement excel - Guide
- Fenix internet on bank statement - Guide
- Gmail security question - Guide
- Sbi bank statement - Guide
- Yahoo mail forgot password and security question - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
1 Jul 2014 à 15:12
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
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