XOR Function in Excel

Hello all. In this short tutorial let’s look at the XOR (exclusive OR) function. XOR is a logical function that check two or more logic and return TRUE or FALSE value. If either of the condition is true, the function returns TRUE. The function returns FALSE if both the condition is true or neither ofContinue reading “XOR Function in Excel”

SWITCH function in Excel

Hello All. Let’s explore SWITCH function in this tutorial. SWITCH is a logical function that would compare given value against pre-defined list of values and returns the first match. One can specify an optional default value to be returned if there is no match. Syntax: =SWITCH(expression, value1, result1, [default_or_value2, result2],..) One can recognize IFS whichContinue reading “SWITCH function in Excel”

NOT function in Excel

Hello all. In this short section, let’s look at NOT function. NOT is a logical function that returns the opposite of logical / boolean value. Syntax: =NOT(logical) Let’s look at a simple example. In the given data set, we are returning TRUE for color Black in the if logic. However, when used NOT with theContinue reading “NOT function in Excel”

IF condition in Excel

Hello All. Let’s look at one of mostly used function – IF function. IF function performs logical test returns the specified value for TRUE or FALSE results. Syntax: =if(logical_test,[value_if_true],[value_if_false]) Here, logical_test can use “=”, “>”, “<“, “>=”, “<=”, “<>” arguments. Let’s look at examples for the IF function, then look at nested IF and IFContinue reading “IF condition in Excel”

TRUE function in Excel

Hello All. Let’s explore the TRUE function in excel. Excel is a logical function that returns the boolean value “TRUE”. Most of the times, IF function is used as the TRUE function just returns the boolean value. Syntax: =TRUE() Let’s look a simple example where the true function is used. In the below dataset, weContinue reading “TRUE function in Excel”

Statistical Functions in Excel

Hello All. In this section, let’s look into all the Statistical functions available in Excel. Here is the table with Syntax and Usage Function Usage Syntax AVEDEV Returns the average of deviations from their mean =avedev(number1,[number2],..) AVERAGE Returns the average of selected arguments =average(number1,[number2],..) AVERAGEA Returns the average of selected arguments including logical values TRUEContinue reading “Statistical Functions in Excel”

Math & Trigonometry Functions in Excel

Hello All. In this section, let’s look into all the Math and Trigonometry functions available in Excel. Here is the table with Syntax and Usage  Function Usage  Syntax  ABS  Returns absolute value of a number =ABS(number)  ACOS  Returns the arccosine of a number (o to pi) =ACOS(number)  ACOSH  Returns inverse hyperbolic cosine =ACOSH(number)  ACOT  ReturnsContinue reading “Math & Trigonometry Functions in Excel”

XLookup Function in Excel

Hello All. In this tutorial let’s look into Xlook up function.   Xlookup is a new function introduced in Excel 365 only which would potentially replace the Vlookup / Hlookup functions. Xlookup searches the range or an array for a match and return the appropriate value from the 2nd array or the return array. Xlookup,Continue reading “XLookup Function in Excel”

Lookup & Reference functions in Excel

Hello all. In this section, let’s look into all the Lookup & Reference functions available in Excel. The below table lists out the function and its usage / syntax. Function Usage Syntax ADDRESS Returns the address of the cell based on row & column number =address(row_num,col_num,[abs_num],[a1],[sheet]) AREAS Returns the number of areas in a reference.Continue reading “Lookup & Reference functions in Excel”

Date & Time functions in Excel

Hello All. In this section, let’s look at all the Date&Time functions in excel. Here is the table with the usage & syntax for all the functions under this category.  Function Usage  Syntax   DATE  Create a date with year, month & date  =Date(year, month, date)  DATEVALUE  Convert a date in text format to a validContinue reading “Date & Time functions in Excel”