Overview of all functions
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 TRUE … Read more
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 Returns … Read more
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. … Read more
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 valid … Read more
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) CODE … Read more
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 the … Read more