Office information

ISEVEN function: The function returns True if the value is even in Excel. Syntax: ISEVEN (value)

ISFORMULA function: The function returns True if that cell refers to a cell containing the formula. Support functions from Excel 2013 onwards. Syntax: ISFORMULA (reference)

ISLOGICAL function: The function returns True if that value is a logical value in Excel. Syntax: ISLOGICAL (value)

ISNA function: The function returns True if the value is an # N / A error value in Excel. Syntax: ISNA (value)

ISNONTEXT function: The function returns True if the value is not a text value in Excel. Application function to check if the value is a text or not. Syntax: ISNONTEXT (value)

ISNUMBER function: The function returns True if the value is numeric. Use the function to check if the value is numeric or not. Syntax: ISNUMBER (value)

ISODD function: The function returns True if the value is odd. Application of functions to check odd and even numbers. Syntax: ISODD (number)

ISREF function: The function returns True if that value is a valid reference value. Application function to check if the value is a reference value or not. Syntax: ISREF (value)

ISTEXT function: The function returns True if the value is text. The function application to check if the value is text. Syntax: ISTEXT (value)

N function: The function returns the numeric value converted from any value. Syntax: N (value)

SHEET function: The function returns the sheet number of the referenced worksheet. Support functions from Excel 2013 onwards. Syntax: SHEET (value)

SHEETS function: The function returns the number of pages in a reference. Support functions from Excel 2013 onwards. Syntax: SHEETS (reference)

TYPE function: The function returns the data type of any value. Application of functions in functions depends on the type of value. Syntax: TYPE (value)

NA function - The function returns the # N / A error value in Excel

The following article details the necessary skills and knowledge to help you quickly get acquainted with Excel 2013/2016. To be able to get acquainted quickly with Excel 2013/2016

The following article details how to create a first Workbook in Excel 2013, 2016. Basic operations to create a complete Workbook in Excel Excel 2013 and 2016.

The following article details how to use functions in Excel 2013 and 2016 to identify and calculate date information. To use the functions related to date information, let's

STDEVA function: The function of estimating standard deviations based on a sample including both text and logical values. Standard deviation is a measure of the dispersion of a

STDEVPA function: The function of estimating standard deviation based on the whole population including both text and logical values. Standard deviation is a measure of the

STEYX function: The function returns the standard error of the predicted value of y for each value of x in the regression. Syntax: STEYX (known_ys, known_xs)