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”
Category Archives: Functions Overview
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”
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”
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”