Скачать или смотреть Excel Logical Functions IF, AND, OR, IF(AND), IF(OR), XOR, IFERROR, IFNA, NESTED IF

In this video, we take a look at Logical Functions in Excel. That functions such as IF, AND, OR, IF(AND), IF(OR), XOR, IFERROR, IFNA, NESTED IF.

Logical functions in Excel
How to use logical function in Excel

AND function. AND function is one of the logical functions in Excel, which determines whether all criteria in a test are TRUE.

The OR function returns TRUE if any of its parameters are TRUE and FALSE if all of its arguments are FALSE.

The IFERROR function can be used to catch and manage errors in a formula. If a formula evaluates to an error, IFERROR returns a value you specify; otherwise, it returns the formula’s result.

The XOR function returns a TRUE value when the number of true inputs is odd otherwise it returns FALSE. Syntax: XOR(logical1, [logical2],…), where logical1, logical2, logical3 etc, are conditions to be evaluated for TRUE or FALSE values.

#excel
#vba
#vbamacro