Excel - IF Functions
Closed
                                    
                        Cde                    
                                    -
                            Aug 13, 2010 at 05:41 AM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:24 PM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:24 PM
        Related:         
- Mutipules of 7
- Excel mod apk for pc - Download - Spreadsheets
- Excel functions in french - Guide
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
- Menu déroulant excel - Guide
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Aug 17, 2010 at 11:24 PM
    Aug 17, 2010 at 11:24 PM
                        
                    You can use
=IF(OR(A2="", A2<=0), "", IF(AND(A2>0, MOD(A2-1,3)=0), "YES", "No"))
            =IF(OR(A2="", A2<=0), "", IF(AND(A2>0, MOD(A2-1,3)=0), "YES", "No"))
