Excel functions

ISBLANK Function in Excel tests if given value or Cell is a Blank or not and returns TRUE if the value is blank;otherwise returns FALSE . Learn more .

AND Function in Excel tests two or more conditions to see if they are all true.It returns TRUE if all conditions are TRUE, returns FALSE if any of the conditions is FALSE. AND function would be used in conjunction with another function such as IF function.

ISEVEN Function in Excel - formula returns TRUE if the given value is even. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

IFERROR Function in Excel - formula check a value and it returns the value if there is no error or else it returns the specified value_if error. Learn more.

AVERAGEIF Function in Excel find the Average of all numbers in a range based on a given criteria. Learn Formulas, Excel and VBA with examples explained.

IF Function in Excel - formula helps us to check a condition, it returns one value if a specified condition is TRUE, or another value if the condtion is FALSE

CHOOSE Function in Excel - formula returns a value from a list of values based on a given index position. Learn Formulas, Excel and VBA with examples.

INDEX Function in Excel - formula returns either the value or the reference to a value from a table or range. Learn Formulas, Excel and VBA with examples.

MATCH Function in Excel - formula searches for a value in an array and returns the relative position of that item. Learn Formulas, Excel and VBA with examples.