# Excel functions

/Tag: Excel functions

## CELL Function in Excel

CELL Function in Excel - formula returns information about the contents, formatting or location of a given cell. Learn Formulas, Excel and VBA with examples

By |April 14th, 2013|Excel Formulas|0 Comments

## REPLACE Function in Excel

REPLACE Function in Excel - formula replaces a sequence of characters/words in a string with another set of characters/words. Learn Formulas with examples .

By |April 11th, 2013|Excel Formulas|1 Comment

## LEN Function in Excel

LEN Function in Excel - formula Returns the length of the specified string. Learn Formulas, Excel and VBA with examples explained in our free tutorials.

By |April 11th, 2013|Excel Formulas|0 Comments

## REPT Function in Excel

REPT Function in Excel - formula returns a repeated text value a specified number of times. Learn Formulas, Excel and VBA examples in our free tutorials.

By |April 11th, 2013|Excel Formulas|0 Comments

## VALUE Function in Excel

VALUE Function in Excel - formula helps to convert a number in a text format into a number format. Learn Formulas, Excel and VBA examples free tutorials.

By |April 11th, 2013|Excel Formulas|0 Comments

## TYPE Function in Excel

TYPE Function in Excel - formula returns information (integer) about the data type of a supplied value. Learn more Formulas, Excel and VBA with examples.

By |April 10th, 2013|Excel Formulas|0 Comments

## NA Function in Excel

NA Function in Excel - formula returns excel #NA Error. Learn more Formulas, Excel and VBA concepts with examples explained in our free tutorials.

By |April 7th, 2013|Excel Formulas|0 Comments

## N Function in Excel

N Function in Excel- formula converts data into numeric values, converts a non-number value to a number, a date to a serial number, the logical value TRUE to 1 and all other values to 0

By |April 5th, 2013|Excel Formulas|0 Comments

## ERROR.TYPE Function in Excel

ERROR.TYPE Function in Excel - formula returns error number of the given error value, returns #NA if the given value is not an error . Learn more Formulas

By |March 31st, 2013|Excel Formulas|0 Comments

## ISNUMBER Function in Excel

ISNUMBER Function in Excel - formula returns TRUE if the given value is a number, otherwise returns FALSE. Learn Formulas, Excel and VBA with examples.

By |March 27th, 2013|Excel Formulas|0 Comments

## ISTEXT Function in Excel

ISTEXT Function in Excel - formula returns TRUE if the given value is a string/text, otherwise returns FALSE. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |March 25th, 2013|Excel Formulas|0 Comments

## ISREF Function in Excel

ISREF Function in Excel - formula returns TRUE if the given value is a reference, otherwise returns FALSE. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |March 24th, 2013|Excel Formulas|0 Comments

## ISNA Function in Excel

ISNA Function in Excel - formula returns TRUE if the given value is #NA, otherwise returns FALSE. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |March 23rd, 2013|Excel Formulas|0 Comments

## ISLOGICAL Function in Excel

ISLOGICAL Function in Excel - formula returns TRUE if the given value is logical (TRUE or FALSE), otherwise returns FALSE. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |March 21st, 2013|Excel Formulas|0 Comments

## ISERROR Function in Excel

ISERROR Function in Excel - formula tests if given value is an error or not(is considers #N/A as an error) and returns TRUE if it finds error;otherwise returns FALSE

By |March 18th, 2013|Excel Formulas|0 Comments

## ISERR Function in Excel

ISERR Function in Excel - formula tests if given value is an error or not(EXCEPT for the #N/A error) and returns TRUE if it finds error;otherwise returns FALSE

By |March 15th, 2013|Excel Formulas|0 Comments

## ISBLANK Function in Excel

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 .

By |March 12th, 2013|Excel Formulas|0 Comments

## AND Function in Excel

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.

By |March 10th, 2013|Excel Formulas|0 Comments

## ISEVEN Function in Excel

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.

By |March 7th, 2013|Excel Formulas|0 Comments

## IFERROR Function in Excel

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.

By |March 4th, 2013|Excel Formulas|0 Comments