{"id":96655,"date":"2021-06-25T09:00:36","date_gmt":"2021-06-25T03:30:36","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=96655"},"modified":"2021-06-07T17:05:11","modified_gmt":"2021-06-07T11:35:11","slug":"logical-functions-in-excel","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/logical-functions-in-excel\/","title":{"rendered":"Logical Functions in Excel – AND, OR, XOR, NOT"},"content":{"rendered":"

Logical functions and formulas help the user to make decisions on the dataset. The function helps in combining multiple conditions and it also helps to evaluate whether a condition is true or false.\u00a0<\/span><\/p>\n

A condition is an expression that evaluates whether it is true or false. The expression also helps in determining the data type of the cell. It also helps in checking if the value in the cell is greater than, lesser than or equal to a specified value.<\/span><\/p>\n

Logical Functions in Excel<\/h3>\n

Logical functions are being used widely in MS Excel worksheet to evaluate and analyze the data present in the sheet.<\/span><\/p>\n

Let’s look at some important functions in MS-Excel. These functions and formulas in excel help to analyze and evaluate the data in an organized manner.\u00a0<\/span><\/p>\n

Logical functions and its description<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
Logical Function<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
And<\/span><\/td>\nAnd condition checks multiple criteria and returns true if every condition satisfies.<\/span><\/td>\n<\/tr>\n
If<\/span><\/td>\nIf the criteria is met, it returns true or else it returns false.<\/span><\/td>\n<\/tr>\n
Iferror<\/span><\/td>\nIf an error occurs in a cell, it returns a value.<\/span><\/td>\n<\/tr>\n
Ifna<\/span><\/td>\nReturns true if #N\/A error occurs.<\/span><\/td>\n<\/tr>\n
not<\/span><\/td>\nReturns true if the criteria becomes false and returns false if criteria is met.<\/span><\/td>\n<\/tr>\n
OR<\/span><\/td>\nUsed when evaluating multiple conditions. It returns true if any or all of the conditions are true or else it returns false.<\/span><\/td>\n<\/tr>\n
True<\/span><\/td>\nTrue function compares the result of a function is either true or false. This function returns the output as either true or false.<\/span><\/td>\n<\/tr>\n
False<\/span><\/td>\nFalse function compares the result of a function is either true or false. This function returns the output as either true or false.<\/span><\/td>\n<\/tr>\n
Switch\u00a0<\/span><\/td>\nThis evaluates a list of values and returns the first match value. If there is no match value available then an optional default value is returned.\u00a0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Let’s get into the IF formula and its parameters.<\/span><\/p>\n

IF Function in Excel<\/h3>\n

The IF Function is one of the logical functions and the user can use IF statements on the worksheet to evaluate the values to true or false. If it meets the user condition then it shows the output as true or else it returns false. The IF function can also combine with the functions such as AND, OR.\u00a0<\/span><\/p>\n

Note:\u00a0<\/b><\/p>\n