The Microsoft Excel Logical Functions !
AND Function.
The Excel AND Function help you to checks whether all arguments are TRUE then return the result TRUE.
Syntax : - The AND function syntax has the following arguments: - AND(logical1,logical2, ...) Logical1, logical2, ... are conditions you want to test that in excel those can be either TRUE or FALSE. |
Remarks :-
(i) In the Microsoft Excel 2007 You can test (1 to 255) conditions.
(ii) If an array or reference argument contains text or empty cells, those values are ignored in this function.
(iii) If the specified range contains no logical values, AND Function returns the #VALUE! Error value as a Result. Click To Download File
(i) In the Microsoft Excel 2007 You can test (1 to 255) conditions.
(ii) If an array or reference argument contains text or empty cells, those values are ignored in this function.
(iii) If the specified range contains no logical values, AND Function returns the #VALUE! Error value as a Result. Click To Download File
Syntax : -
IFERROR(value,value_if_error)
The IFERROR function syntax has the following arguments : -
Value :- Is the argument that is checked for an error.
Value_if_error :- Is the value to return if the formula evaluates to an error.
The following error types are evaluated by IFERROR Function [ #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! ]
Remarks :-
If value or value_if_error is an empty cell, IFERROR treats it as an empty string value Click To Download File
IFERROR(value,value_if_error)
The IFERROR function syntax has the following arguments : -
Value :- Is the argument that is checked for an error.
Value_if_error :- Is the value to return if the formula evaluates to an error.
The following error types are evaluated by IFERROR Function [ #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! ]
Remarks :-
If value or value_if_error is an empty cell, IFERROR treats it as an empty string value Click To Download File
NOT(logical)
The NOT function syntax has the following arguments : -
Logical : - Is a value or expression or Condition that can be evaluated to TRUE or FALSE.
Remarks : -
If logical is FALSE, NOT returns TRUE, if logical is TRUE, NOT returns FALSE. Click To Download File
The NOT function syntax has the following arguments : -
Logical : - Is a value or expression or Condition that can be evaluated to TRUE or FALSE.
Remarks : -
If logical is FALSE, NOT returns TRUE, if logical is TRUE, NOT returns FALSE. Click To Download File
Or into a formula and Microsoft Excel interprets it as the logical value TRUE. Click To Download File
FALSE Function.
The Excel FALSE Function Returns the logical value FALSE.
Syntax : - FALSE( ) Remarks:- You can also type the word “FALSE “directly onto a worksheet or into a formula and Microsoft Excel interprets it as the logical value FALSE. |
IF Function.
The Excel IF Function Checks whether a given condition is met then returns one value if TRUE, and another values if FALSE.
Syntax : - The IF function syntax has the following arguments : - IF(logical_test,value_if_true,value_if_false) Logical test :-is any value or expression (condition) that can be evaluated to TRUE or FALSE. |
value_if_true :- Is expression (condition) evaluated TRUE then Return the Value (e.g. "Within budget)
value_if_false :- Is expression (condition) evaluated FALSE then Return the Value (e.g. "Out of budget)
A5=100 is a logical expression (condition) , if the value in cell A5 is equal (=) to 100, the expression (condition) evaluates to TRUE. Otherwise, the expression (condition) evaluates to FALSE. Click To Download File
value_if_false :- Is expression (condition) evaluated FALSE then Return the Value (e.g. "Out of budget)
A5=100 is a logical expression (condition) , if the value in cell A5 is equal (=) to 100, the expression (condition) evaluates to TRUE. Otherwise, the expression (condition) evaluates to FALSE. Click To Download File
Logical1, logical2, ... Are conditions you want to test that in excel those can be either TRUE or FALSE.
(i) In the Microsoft Excel 2007 You can test (1 to 255) conditions.
(ii) If an array or reference argument contains text or empty cells, those values are ignored in this function.
(iii) If the specified range contains no logical values then OR Function returns the #VALUE! Error value as a Result. Click To Download File
(i) In the Microsoft Excel 2007 You can test (1 to 255) conditions.
(ii) If an array or reference argument contains text or empty cells, those values are ignored in this function.
(iii) If the specified range contains no logical values then OR Function returns the #VALUE! Error value as a Result. Click To Download File