AND

Returns TRUE if all arguments are true.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Boolean

Examples

=AND(A1>5, B1<10)

	A	B
1	10	2

Result true

Syntax

AND(logical…)

logical…: boolean required

EQTrue when two values are equal. FALSEReturns the logical value FALSE. GTTrue when the first number is greater. GTETrue when the first number is greater or equal. IFReturns one value if condition is true, another if false. IFERRORReturns value if no error, otherwise alternate.