What is SWITCH Function in Excel? The SWITCH function is one of the Logical functions of Excel. It evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value is returned. We can find this function in the Logical of insert function […]

What is OR function in Excel? The OR function is one of the Logical functions of Excel. It checks whether any of the arguments are TRUE, and returns TRUE or FALSE. This function returns FALSE only if all arguments are FALSE. We can find this function in the Logical category of the insert function Tab. How to […]

What is the NOT function in Excel? The NOT function is one of the Logical functions of Excel. this function changes false to true or true to false. We can find this function in the Logical of the insert function Tab. How to use NOT function in excel 1. Click on an empty cell (like F5 ) 2. […]

What is IF function in Excel? The IF function is one of the Logical functions of Excel. It checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. We can find this function in the Logical category of the insert function Tab. How to use IF function in excel 1. Click on […]

What is IFNA function in Excel? The IFNA function is one of the Logical functions of Excel. It returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression. We can find this function in the Logical of the insert function Tab. How to use IFNA function in excel 1. Click […]

What is IFS function in Excel? The IFS function is one of the Logical functions of Excel. It checks whether one or more conditions are met and returns a value corresponding to the first TRUE condition. We can find this function in the Logical category of the insert function Tab. How to use IFS function in excel 1. […]

What is XOR function in Excel? The XOR function is one of the Logical functions of Excel. It returns a logical Exclusive of all arguments. We can find this function in the Logical of the insert function Tab. How to use XOR function in excel 1. Click on an empty cell (like F5 ) 2. Click on the fx icon […]

What is TRUE function in Excel? The TRUE function is one of the Logical functions of Excel. It returns the logical value true. We can find this function in the Logical of insert function Tab. How to use TRUE function in excel 1. Click on an empty cell (like F5 ) 2. Click on the fx icon (or press shift+F3) 3. […]

What is IFERROR function in Excel? The IFERROR  function is one of the Logical functions of Excel. It returns value_if_error if the expression is an error and the value of the expression itself otherwise. We can find this in the Logical functions of the insert the function Tab. How to use IFERROR function in excel 1. Click […]

What is FALSE function in Excel? The FALSE function is one of the Logical functions of Excel. It returns the logical value false. We can find this function in the Logical of the insert function Tab. How to use FALSE function in excel 1. Click on an empty cell (like F5 ) 2. Click on the fx icon (or press shift+F3) […]