EXCEL

and 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.

EXCEL AND

=IF(AND(A1>0,A1<5), "Approved", "Denied")