•       
            
        
          
          
        
                
        
                
        
          
          
        
          
        
                          
            
          
          
                
            
          
        
        
        
          
                          
        
                          
      Excel OR Function
                              
        
                          
            
          
          
                
      Excel OR function
            
            
      Summary 
          
                
      The OR function is a logical function to test multiple conditions at the same time. OR returns either TRUE or FALSE. For example, to test A1 for either "x" or "y", use =OR(A1="x",A1="y"). The OR function can be used as the logical test inside the IF function to avoid extra nested IFs, and can be combined with the AND function.
            
            
      Purpose 
          
                
      Test multiple conditions with OR
            
            
      Return value 
          
                
      TRUE if any arguments evaluate TRUE; FALSE if not.
            
            
      Syntax 
          
                
      =OR (logical1, [logical2], ...)
            
            
      Arguments 
          
                
          
                
      • logical1 - The first condition or logical value to evaluate.
      • logical2 - [optional] The second condition or logical value to evaluate.
            
            
            
      Usage notes 
          
                
      Use the OR function to test multiple conditions at the same time, up to 255 conditions total.
      For example, to test if the value in A1 OR the value in B1 is greater than 75, use the following formula:
      =OR(A1>75,B1>75)
      OR can be used to extend the functionality of functions like IF. Using the above example, you can supply OR as the logical_test for an IF function like so:
      =IF(OR(A1>75,B1>75), "Pass", "Fail")
      This formula will return "Pass" if the value in A1 is greater than 75 OR the value in B1 is greater than 75.
      Array form
      If you enter OR as an array formula, you can test all values in a range against a condition. For example, this array formula will return TRUE if any cell in A1:A100 is greater than 15:
      ={OR(A1:A100>15}
      Note: this is an array formula and must be entered with control + shift + enter, except in Excel 365.
      Notes
      • Each logical condition must evaluate to TRUE or FALSE, or be arrays or references that contain logical values.
      • Text values or empty cells supplied as arguments are ignored.
      • The OR function will return #VALUE if no logical values are found
            
          
                
        
                          
            
          
          
                
            
          
        
            
        
            
      Related functions 
          
                
          
          
                
      Excel AND function
            
      Excel AND Function
          
                
      The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1...
            
            
          
                
      500 Formula Examples, thoughtfully explained.
            
          
        
            
        
                    
        
          1. 
http://www.ilxs21.cn |

http://m.ilxs21.cn |

http://wap.ilxs21.cn |

http://3g.ilxs21.cn |

http://4g.ilxs21.cn |

http://5g.ilxs21.cn |

http://mobile.ilxs21.cn |

http://vip.ilxs21.cn |

http://ios.ilxs21.cn |

http://anzhuo.ilxs21.cn |

http://7.ilxs21.cn |

http://51b45c.ilxs21.cn |

http://1c8.ilxs21.cn |

http://www.ilxs21.cn/b8.html |

http://www.ilxs21.cn/94d.html |

http://www.ilxs21.cn/e6.html |

乖握住它自己放进去