Monday, February 12, 2018

logical function


logical function

And function
The Microsoft Excel AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.
syntax
AND( condition1, [condition2], ... )


Parameters  Arguments
condition1
The first condition to test whether it is TRUE or FALSE.
condition2, 
Optional. Additional conditions to test whether they are TRUE or FALSE. There can be up to 30 conditions in total.


OR function
The Microsoft Excel OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.
syntax
OR( condition1, [condition2, ... Condition n] )


Parameters
condition1
A condition to test that can either be TRUE or FALSE.
condition2
 Condition Optional. Conditions to test that can either be TRUE or FALSE. There can be up to 30 conditions. 


If function
The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE.
Syntax
 IF( condition, [value if true], [value if false] )


parameters
condition ;
The value that you want to test.
Value if true Optional; 
It is the value that is returned if condition evaluates to TRUE.
Value if false Optional; 
It is the value that is return if condition evaluates to FALSE.


Iferror function
The Microsoft Excel IFERROR function returns an alternate value if a formula results in an error. It will check for errors such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL.
Syntax
IFERROR( formula, alternate value )


parameter
Formula  ;
The formula or value that you want to test.
Alternate value ;
The alternate value that is returned if the formula results in an error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL). Otherwise, the function will return the result of the formula if no error occurs.


True function
The Microsoft Excel TRUE function returns a logical value of TRUE.
Syntax
  TRUE( )
parameters
There are no parameters or arguments for the TRUE function

False function
The Microsoft Excel FALSE function returns a logical value of FALSE.
Syntax
  FALSE( )
parameters
There are no parameters or arguments for the TRUE function

Not function
The Microsoft Excel NOT function returns the reversed logical value
Syntax
  NOT( logical value )


parameters
Logical value
  An expression that either evaluates to TRUE or FALSE. If used with an expression of TRUE, then FALSE is returned. If used with an expression of FALSE, then TRUE is returned.


No comments:

Post a Comment

Data base function

Database function Daverage function      Averages the values in a field (column) of records in a list or database that match conditio...