Help me in using IF formula with condition
Closed
                                    
                        arun                    
                                    -
                            Jun 26, 2010 at 02:38 AM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2010 at 07:44 AM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2010 at 07:44 AM
        Related:         
- Help me in using IF formula with condition
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Formula to calculate vat in excel - Guide
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Jun 26, 2010 at 07:44 AM
    Jun 26, 2010 at 07:44 AM
                        
                    Lets say Revenue is in cell A1 and you want the word to appear in b1
then in b1 add
=IF(OR(A1>150, A1<50, A1=""), "", IF(A1>=100,"BIG", IF(A1>=70, "MEDIUM","SMALL")))
            then in b1 add
=IF(OR(A1>150, A1<50, A1=""), "", IF(A1>=100,"BIG", IF(A1>=70, "MEDIUM","SMALL")))
