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
        Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 1, 2014 at 03:12 PM
        Related:         
- Question about my if statement
 - Fenix internet on bank statement - Guide
 - How can i recover my yahoo account with security question - Guide
 - Gmail security question - Guide
 - Sbi statement download - Guide
 - Vba case statement with string - Guide
 
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
    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
            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