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:
- Sbi statement excel password
- Excel mod apk for pc - Download - Spreadsheets
- More than 1 if statement excel - Guide
- Vat calculation excel - Guide
- Arrow keys not working in excel - Guide
- Excel clear formatting - 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