LOGICAL FUNCTIONS IN MS EXCEL
Logical functions are some of the most popular and useful in Excel . They can test values in other cells and perform actions dependent upon the result of the test . This helps us to automate tasks in our spreadsheets . The logical function are AND , IF , OR ,TRUE, FALSE , XOR , SWITCH , IFNA , IFERROR , IFS and NOT etc . Logical functions are the repository to implement the logical relationships amongst cell ranges included in the formula .
LOGICAL FUNCTIONS
There are total 11 logical functions in MS Excel . These 11 logical functions are given below .
1.) AND : Check whether all arguments are TRUE , and returns TRUE if all arguments are TRUE .
2.) FALSE : Returns the logical value FALSE , this function takes no arguments .
3.) IF : Checks whether a condition is met , and returns one value if TRUE , and another value if FALSE .
4.) IFERROR : Returns value if error if expression is an error and the value of the expression itself otherwise . "Value " is any value or expression or reference .
5.) IFNA : Returns the value you specify if the expression resolves to #N/A , otherwise returns the result of the expression .
6.) IFS : Checks whether one or more conditions are met and returns a value corresponding to the first TRUE condition .
7.) NOT : Change TRUE to FALSE and FALSE to TRUE .
8.) OR : Checks whether any of the arguments are TRUE , and returns TRUE or FALSE . Returns FALSE if all arguments are FALSE .
9.) SWITCH : Evaluates an expression against a list of values and returns the result corresponding to the first matching value . If there is no match , an optional default value is returned .
10.) TRUE : Returns the logical value TRUE . This function takes no arguments .
11.) XOR : Returns a logical 'Exclusive Or ' of all arguments .
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=LOGICAL FUNCTIONS){kind=link}
0 Comments