The logic functions are used to evaluate conditions and act according to the outcome of those conditions. Here are some of the logic functions most used (click on the links to access them)
AND - Evaluates the arguments indicated and returns TRUE if all arguments are true, or FALSE if any argument is not met.
IF - Evaluates the specified condition and returns a value if the condition is true and another value if the condition is false.
IFERROR - Returns a specified value if a formula evaluates to an error; otherwise it returns the result of the formula.
NOT - Evaluates the opposite of the indicated condition.
OR - Evaluates the given arguments and returns TRUE if at least one of the arguments are true, or FALSE if none is met.
No comments:
Post a Comment