For the OR function see row 2 in the image below if one of these conditions is true the function returns a value of TRUE. Excel functions formula charts formatting creating excel dashboard others. The OR function returns TRUE if one or all of the conditions are met and returns FALSE only if no conditions are met.
Now lets use AND function and OR function in one single formula.
If the condition will not match then it will return as a FALSE. We learned about IF with AND Function in Excel and IF with OR Function in Excel previously. The syntax of the OR function OR logical1 logical2 logical3. The most used functions in Excel are the functions that count and sum.