EXCEL

excel or function

FUNCTION FORMAT:  =OR(logic1, logic2, logic3...)
RETURN VALUE:     BOOLEAN (TRUE/FALSE)
REAL EXAMPLE:     =OR(A2>1,A2<100)

// EXAMPLE DESCRITPION:
// Returns TRUE if A2 is greater than 1 or if A2 is less than 100 or both.
// Otherwise it returns FALSE.

and function in excel

FUNCTION FORMAT:  =AND(logic1, logic2, logic3...)
RETURN VALUE:     BOOLEAN (TRUE/FALSE)
REAL EXAMPLE:     =AND(A1=0,B1=1)

// EXAMPLE DESCRITPION
// Returns TRUE if both cell A1 is equal to 0 AND cell B1 is equal to 1. 
// Otherwise it returns FALSE.