BITOR is a bitwise operation which returns a decimal number of two bitwise OR operation. Syntax =BITOR(number1, number2) Arguments number1: First numerical value for BITOR operation  number2: Second numerical value for BITOR operation Behavior We have taken an example for bitwise operation first four numbers are shown how operation perform in bitwise OR If number 1 or number 2 are "1" than BITOR returns "1" otherwise...

BITXOR is a bitwise operation which returns a decimal number of two bitwise XOR operation. Syntax =BITXOR(number1, number2) Arguments number1: First numerical value for BITXOR operation  number2: Second numerical value for BITXOR operation Behavior We have taken an example for bitwise operation first four numbers are shown how operation perform in bitwise XOR If number 1 and number 2 are "1" and/or "0" (Both are same)...

The function BITrSHIFT is a bitwise operation which shifts a bit to the right side of its binary number system Syntax =BITRSHIFT(number,shift_amount) Arguments number: a positive number greater than or equal to "0" Shift_Amount: till how many numbers you want to shift the bit Behavior We have taken an example for a bitwise right shift of the bits on the numerical. The calculation of the bitwise operation is in a binary system  ...

The function BITLSHIFT is a bitwise operation which shifts a bit to the left side of its binary number system Syntax =BITLSHIFT(number,shift_amount) Arguments number: a positive number greater than or equal to "0" Shift_Amount: till how many numbers you want to shift the bit Behavior We have taken an example for a bitwise left shift of the bits on the numerical. The calculation of the bitwise operation is in a binary system ...

TRUE Function is used to show you the value you enter is TRUE or is not a value in applied criteria. TRUE is randomly used function. TRUE Function is used with other logical functions  Syntax of TRUE Function =TRUE() Arguments of TRUE Function It is a return value on the parameters used in formula or function Behavior of TRUE Function Here we have taken an example of the months and its figures to evaluate the TRUE Function Here...

FALSE Function is used to show you the value you enter is FALSE or is not a value in applied criteria. FLASE is randomly used function. FALSE Function is used with other logical functions  Syntax of FALSE Function =FALSE() Arguments of FALSE Function It is a return value on the parameters used in formula or function Behavior of FALSE Function Here we have taken an example of the months and its figures to evaluate the FALSE Function Here...

NOT Function is used to show the opposite of the true value. If we give TRUE in NOT logic it will give FALSE and viseversa. Syntax of NOT Function =NOT(logic) Arguments of NOT Function Logic: The value or logic which is evaluated as TRUE or FALSE Behavior of NOT Function Here we have taken an example in which we have used not function in a logical expression and for the value only You can see that we have used NOTfunctionn for...

OR Function is a logical function which tests the value. If any logic fulfills the condition it will return TRUE otherwise it will return FALSE. OR function is used with other logical function to prevent nested functions. Syntax of OR Function =OR(Logical1,[Logical2],...) Arguments of OR Function Logical1: It is a condition to evaluate the result Logical2: (Optional) It is the second Condition to evaluate the result Behavior of...

IFERROR function is used when a formula has return error like "#N/A", #VALUE", #NAME" at that time the error will hide by a predefined value. Syntax of IFERROR Function =IFERROR(Value, Value if error) Arguments of IFERROR Function Value: return values from reference or formula which contains error Value if error: Predefined value to be shown on behalf of error Behavior of IFERROR Function Here we have taken an example of the...

IF Function is well known conditional function. IF function used with other logical functions also. IF function compares two values or functions and returns conditional true value or false value. =If(Condition, Condition is true, Condition is False) =If(A>B, TRUE, FALSE) Here we have created a function for testing If A is greater than B then IF function will return TRUE If A is not greater than B then IF function will...

IFNA Function is used when a formula returns #N/A Error. in Place of the #N/A Error you can show predefined Value. Syntax =IFNA(Value, Value if na) Arguments Value: The value reference or a formula to test for error Value if na: returns Predefined value when #N/A Error found Behavior Here we have taken an example of the month and its figure. Now we use VLOOKUP function to create #N/A Error. In the F column, it will show #N/A error. Now...

Some of the logical functions that are widely used in excel AND IF IFERROR IFNA NOT OR TRUE FALS...

AND Function is a logical function. AND Function is used for more than one condition also. AND Function will return only "TRUE" and "FALSE" value. If the logical condition of the function Fulfils then AND return "TRUE, otherwise it will return "FALSE" Syntax = AND(logical1,[logical2],...) Arguments logical1: The first condition or first value of the condition logical2: (optional)The second condition or second value of the condition Behavior Here...