GM

ABCD 563 443   CLOSED        
  563 443   #VALUE!        
ABCD 563 443   CLOSED        
ABCD 563 443   CLOSED        
ABCD 563 443   CLOSED        
        OPEN will not show    
        OPEN will not show    
                 
                 
If column A1>1,”open”,”” will show in G1″open” or blank   
                 
but IF(AND(B1>1,C1>1,”closed”,””, will show in G1 “closed” or blank

By: Bikach Chandra Paul

Leave a Reply

Your email address will not be published. Required fields are marked *