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 num…
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 nu…
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 &qu…
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 &quo…
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() A…
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…
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 wh…
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. …
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) …
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, Conditi…
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 erro…
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 th…
