Text Function in Excel

Hello All. In this section, let’s look into all the Text functions available. Here is the table with the usage and syntax for all the Text functions in Excel    Function Usage  Syntax   CHAR  Return a specific character based on the numerical value input =CHAR(number)   CLEAN  Removes all non-printable characters from the text  =CLEAN(text)  CODEContinue reading “Text Function in Excel”

Logical Functions in Excel

Hello All. In this section let’s look into all the logical functions available. Here is the table with the usage and syntax for all the functions.  Function  Usage  Syntax  AND  Test multiple conditions and returns true if all conditions are true  =AND(Logic 1, Logic 2,…)  FALSE  Returns the logical value FALSE  =FALSE()  TRUE  Returns theContinue reading “Logical Functions in Excel”

AND function in Excel

Hello All. In this tutorial let’s explore the AND function in excel. AND is a logical function used to check one or more conditions and return a “True” value if the conditions are met and “False” if otherwise. Syntax: =AND(logic1, [logic2],[logic3]…) Let’s look at a simple example to start with. In the below example, weContinue reading “AND function in Excel”

OR Function in Excel

Hello All. In this tutorial let’s explore the OR function in Excel. OR is a logical function used to check multiple conditions and returns TRUE if one of the conditions meet. Syntax: =OR(logic1, logic2,[logic3],..) Let’s start with a simple example. In the below example, let’s write the OR function to return “True” when the valueContinue reading “OR Function in Excel”

FALSE function in Excel

Hello all. Let’s look at FALSE function in excel. This is a very short tutorial as the FALSE function is classified as compatibility function and not needed in most of the cases. FALSE function would return the logical value / Boolean value “False” directly in the formula. Syntax: =False() Let’s look at a simple exampleContinue reading “FALSE function in Excel”

IFNA Function in Excel

Hello all. Here is a very quick run through of the IFNA function in excel. Please note that this function is available only from Excel 2013 versions. IFNA was introduced specifically to trap the “#NA” error and return a specific value for the error condition.  Syntax: =IFNA(value, Value_ifna) Let’s look at the example below. AContinue reading “IFNA Function in Excel”

IFS Function in Excel

Hello all. In this tutorial, let’s look at one of the new functions that’s available in Excel 2019 and 365 versions – IFS. IFS function is used to test multiple conditions and returns the first TRUE result. Unlike the IF function, IFS allows to test multiple conditions without nesting. Let’s look at the syntax andContinue reading “IFS Function in Excel”

IFERROR Function in Excel

Hello all. Let’s look at the IFERROR function in this tutorial. IFERROR function is used to trap errors and return a specific value for those error conditions. The function would trap the following errors: “#NA”, “#value!”, “#ref!”, “#div/0!”, “#num!”, “#Name?”, “#Null!” Syntax: =iferror(value, value_if_error) Here, the value can be a specific value or a referenceContinue reading “IFERROR Function in Excel”