CODE EXAMPLE FOR EXCEL

excel and formula

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.