Engineering

BITRSHIFT Function in Excel

Returns a number shifted right by the specified number of bits.

Syntax

  • =BITRSHIFT(number, shift_amount)

Arguments

  • number (required): Number to shift
  • shift_amount (required): Bits to shift right

Examples

  • =BITRSHIFT(16, 2) - Shift 16 right by 2 bits - Result: 4

BITRSHIFT in technical sheets

  • Document units in adjacent cells — many engineering functions require exact unit strings.
  • Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
  • Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

  • #NUM! if shift_amount < 0

Use cases

  • Bit manipulation
  • Division by powers of 2
  • Programming

Frequently asked questions

  • What is the BITRSHIFT function in Excel? BITRSHIFT returns a number shifted right by the specified number of bits. The syntax is =BITRSHIFT(number, shift_amount). Typical use cases include bit manipulation, division by powers of 2, programming.
  • How do I use the BITRSHIFT function? To use BITRSHIFT, type =BITRSHIFT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is BITRSHIFT not working in my Excel? Common issues with BITRSHIFT include #NUM! if shift_amount < 0. Start by checking the syntax =BITRSHIFT(number, shift_amount), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.