1. AND:- In Microsoft Excel “AND” function is a logical function
used to need more than one condition at the same time and returns the result
either TRUE or FALSE.
Syntax of AND function:-
=AND(logical1,[logical2],….)
Arguments:-
logical1:- The first condition or logical value
to execute.
logical2:- The second condition or logical value
to execute. It is an optional part.
Example of AND function:-
The following pictures show the example of the AND function.
2. IF:- In Microsoft Excel “IF” function executes for a logical
text and returns two values. One for TRUE
result and another for FALSE result.
If wants to use more than one condition can be tested by nesting IF function.
Syntax of IF function:-
=IF(logical_test,[value_if_true],[value_if_false])
Arguments:-
logical_test:- A logical expression that can be executed
as a TRUE or FALSE.
value_if_true:- The value returns when logical test
execute as TRUE and it is an
optional part.
value_if_false:- The value returns when logical test
execute as FALSE and it is an
optional part.
Example of IF function:-
The
following pictures show the example of the
IF function.
3. FALSE:- In Microsoft Excel “FALSE” function returns the logical
value FALSE as output when used in a
blank cell.
Syntax of FALSE function:-
=FALSE()
Example of FALSE function:-
The
following pictures show the example of the
FALSE function.
4. IFERROR:- In Microsoft Excel “IFERROR” function returns a user
defined result when a formula generates an error and a actual result is shown
when no error is detected.
Syntax of IFERROR function:-
=IFERROR(value,value_if_error)
Arguments:-
value:- Reference or formula to verify for an
error.
value_if_error:- If the error is found the value
returns.
Example of IFERROR function:-
The
following pictures show the example of the
IFERROR function.
5. NOT:- In Microsoft Excel “NOT” function returns the opposite of
a given Boolean value (i.e. TRUE or FALSE). If you give TRUE “NOT” function returns FALSE
when you give FALSE “NOT” function returns TRUE.
Syntax of NOT function:-
=NOT(logical)
Arguments:-
logical:- Logical expression of a value that
can be returned as TRUE or FLASE.
Example of NOT function:-
The
following pictures show the example of the
NOT function.
6. OR:- In Microsoft Excel “OR” function is a logical function
used to need multiple condition at the same time and returns the result either TRUE or FALSE.
Syntax of OR function:-
=OR(logical1,[logical2],….)
Arguments:-
logical1:- The first condition or logical value
to execute.
logical2:- The second condition or logical value
to execute. It is an optional part.
Example of OR function:-
The
following pictures show the example of the
OR function.
7. TRUE:-In Microsoft Excel “TRUE” function returns the logical
value TRUE as output when used in a
blank cell.
Syntax of TRUE function:-
=TRUE()
Example of TRUE function:-
The following pictures show the example of the TRUE function.
0 Comments:
Post a Comment