BITRSHIFT Function in Excel – Bit right shift Operation in Excel

BITRSHIFT Function in Excel returns the right shift of supplied integers by specified number of bits.

Note: BITRSHIFT Function was only introduced from Excel 2013 onwards

Bit right shift Explained

Bit right shift operator shifts all bits towards right by certain number of specified bits. Let’s see an example of right shift of 212

212 = 11010100 (In binary)

Right shift by 2 bit gives
212>>2 = 00110101

Right shift by 7 bits gives
212>>7 = 00000001

Right shift by 0 gives
212>>0 =11010100

 

Syntax of BITRSHIFT Function in Excel (BIT RIGHT SHIFT OPERATION IN EXCEL):

BITRSHIFT (number, shift_amount)

Where

  • number – The Number that you want to perform right shift operation on
  • shift_amount – An integer that specifies the number of bits to be shifted right

 

Example of BITRSHIFT Function in Excel (BIT RIGHT SHIFT OPERATION IN EXCEL):

FORMULA:

BITRSHIFT Function in Excel 1

RESULT:

BITRSHIFT Function in Excel 2

NOTE: #NUM!   – Error occurs if

  • The supplied number arguments is a non-integer;
  • The supplied number arguments is negative or is greater than (2^48)-1.

previous BITRSHIFT Function in Excel                                                                                                                 next BITRSHIFT Function in Excel