Excel functions

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

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

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

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

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

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

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.

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.

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.

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.

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

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