[ ] indicates optional parameters
AND(logical1, [logical2, ...])AND(logical1, [logical2, ...])
Returns TRUE if all of the input values are TRUE, otherwise FALSE.
logical1, ... | The values that you want to check. |
Returns the logical value FALSE.
IF(logical_test, [value_if_true], [value_if_false])
Returns one of two other values depending no whether the logical test evaluates to TRUE or FALSE.
logical_test | An expression that results in TRUE or FALSE. |
value_if_true | The value to be returned of the logical test is TRUE. If this parameter is omitted it defaults to 0. |
value_if_false | The value to be returned of the logical test is FALSE. If this parameter is omitted it defaults to FALSE. |
Returns TRUE if the input expression evaluates to FALSE, and vice versa.
logical | The logical expression for which you want the opposite value. |
Returns TRUE if any of the input values are TRUE, otherwise FALSE.
logical1, ... | The values that you want to check. |
Returns the logical value TRUE.