Menu
EXCEL BITRSHIFT FUNCTION
Excel BITRSHIFT Function Introduction
The BitRShift function in Excel produces an integer that has been shifted right by a given amount of bits.
Description of Excel BITRSHIFT Function
Syntax:
=BITRSHIFT( number, shift_amount )
Parameter:
- The following arguments are provided:
Number:
- The number on which you wish the operation to be performed (must be a positive integer).
Shift_amount :
- An integer value indicating how many bits the provided number should be shifted by.
Step By Step Guide of BITRSHIFT Function
Example:
The binary representation of 20 is 10100.
101 is 10100 moved right by two positions.
This value is returned as an integer in decimal form 5.
Key Points
- #NUM! – Occurs if any of the following conditions are met: the given number argument is a non-integer; the supplied number argument is negative or greater than (248); -1. \s
- #VALUE! – Occurs when one or both of the given arguments is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
