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”