If then statement
Closed
                                    
                        Excelley                    
                                    -
                            Jul 30, 2010 at 09:40 AM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 10:05 AM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 10:05 AM
        Related:         
- If then statement
 - Fenix internet on bank statement - Guide
 - Sbi statement download - Guide
 - Vba case statement with string - Guide
 - Excel if statement with text - Guide
 - How many if statements can you nest - Guide
 
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Jul 30, 2010 at 10:05 AM
    Jul 30, 2010 at 10:05 AM
                        
                    You cannot have it like that.
IF(I1<>"",A1:H1)
you can have done some to range(a1:h1) but if you just want to show the values of a1, h1. This is not possible to do so in one cell like that
            IF(I1<>"",A1:H1)
you can have done some to range(a1:h1) but if you just want to show the values of a1, h1. This is not possible to do so in one cell like that