AND

=AND(1<B4; B4<100)

Logical AND operation.Returns TRUE if all values within the list are TRUE; returns FALSE if one or more values within the list evaluates to FALSE.

FALSE

=FALSE()

Returns the logical value FALSE.

IF        

=IF(A10<=100; "málo", "moc")

the logical expression, the value to return if the expression succeeds, the value to return the expression fails.                Returns the second argument if the logical expression evaluates to TRUE and the third argument otherwise.

NOT

=NOT(1>D4)

Logical NOT operation.Reverses the value of its argument.

OR        

=OR(A1>=10; A1<=–10)

Logical OR operation.Returns TRUE if any argument is TRUE; returns FALSE if all values within the list evaluate to FALSE.

TRUE

=TRUE()        

Returns the logical value TRUE.