Category: Formulas & Functions

How to Use Excel AND Function

Use of AND function:Use AND function to check one or more conditions at the same time. It returns TRUE if all the supplied logical arguments meet the criteria otherwise FALSE. …

LEN Function in Excel

The Excel LEN is an in-built function hence frequently used in day to day life. The function is really simple and easy to use. It belongs to Text family which …

COUNTBLANK Function in Excel

There are many features that makes Microsoft Excel so user friendly and robust. Some of them are its in-built functions that gives flexibility to users to play with spreadsheet. The …

COUNTA Function in Excel

There are several COUNT functions in Microsoft Excel to count the cells that contains specific type of data in the given range or list of arguments.The COUNTA function counts all …

COUNT Function in Excel

COUNT function counts the number of cells that contains numbers in a given range or within the list of arguments.UsesThere are many in-built functions in Microsoft Excel and COUNT is …

SUM Function in Excel

As the name suggests, SUM function in Excel is used to sum-up all the numbers supplied in the arguments or in the range of cells. It is one of the …