Learn Free About Conditional Functions

Excel Logical Functions Boolean Operator Functions AND Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise OR Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise XOR Returns a logical Exclusive Or of all arguments (New in Excel 2013) NOT Returns a logical value that is the opposite of a user supplied logical value or expression (ie. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is FALSE)

Conditional Functions IF Tests a user-defined condition and returns one result if the condition is TRUE, and another result if the condition is FALSE IFERROR Tests if an initial supplied value (or expression) returns an error, and if so, returns a supplied value; Otherwise the function returns the initial value. (New in Excel 2007) IFNA Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression (New in Excel 2013) Functions Returning Constant Values TRUE Simply returns the logical value TRUE FALSE Simply returns the logical value FALSE
Error Information Functions
ISERROR		Tests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE
ISERR		Tests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returns FALSE
ISNA		Tests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returns TRUE; Otherwise returns FALSE
ERROR.TYPE		Tests a supplied value and returns an integer relating to the supplied value's error type
Numerical Information Functions
ISNUMBER		Tests if a supplied value is a number, and if so, returns TRUE; Otherwise, returns FALSE.
ISEVEN		Tests if a supplied number (or expression) is an even number, and if so, returns TRUE; Otherwise, returns FALSE.
ISODD		Tests if a supplied number (or expression) is an odd number, and if so, returns TRUE; Otherwise, returns FALSE.
N		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.
Function Returning a Constant Value
NA		Returns the Excel #N/A error
	Other Data Type Functions
	ISBLANK	Tests if a supplied cell is blank (empty), and if so, returns TRUE; Otherwise, returns FALSE
	ISLOGICAL	Tests if a supplied value is a logical value, and if so, returns TRUE; Otherwise, returns FALSE
	ISTEXT	Tests if a supplied value is text, and if so, returns TRUE; Otherwise, returns FALSE
	ISNONTEXT	Tests if a supplied value is text, and if it is NOT, returns TRUE; Otherwise, returns FALSE
	ISREF	Tests if a supplied value is a reference, and if so, returns TRUE; Otherwise, returns FALSE
	ISFORMULA	Tests if a supplied cell contains a formula and if so, returns TRUE; Otherwise, returns FALSE (New in Excel 2013)
	TYPE	Returns information about the data type of a supplied value
	General Information Functions
	CELL	Returns information about the contents, formatting or location of a given cell
	SHEET	Returns the sheet number relating to a supplied reference (New in Excel 2013)
	SHEETS	Returns the number of sheets in a reference (New in Excel 2013)
	INFO	Returns information about the the current operating environment