The NOT function, one of many EXCEL logical functions, is used to evaluate a single logical condition, passed as an argument to the function. It will return the opposite of that argument. I.e.:
If the evaluated logical condition is TRUE, the function will return FALSE.
If the evaluated logical condition is FALSE the function will return TRUE.
Syntax
NOT(logical)
Logical is [...]
The OR function , one of many EXCEL logical functions, is used to evaluate a number of logical conditions, passed as arguments to the function. The function will return a single value of TRUE or FALSE.
Syntax
OR(logical1, logical2 ………)
logical1 and logical2 are conditions that evaluate to TRUE or FALSE. The first argument is required the second [...]
The AND function , one of many EXCEL logical functions, is used to evaluate a number of logical conditions, passed as arguments to the function. The function will return a single value of TRUE or FALSE.
Syntax
AND(logical1, logical2 ………)
logical1 and logical2 are conditions that evaluate to TRUE or FALSE. The first argument is required the second [...]
The IF function, one of many EXCEL logical functions, is used to evaluate a logical condition, passed as an argument to the function. The function will then return one of two values specified as the second argument or the third argument in the function. It will return the second argument if the test evaluates to [...]
