BITRSHIFT Function
Shifts a number's bits to the right (divides by a power of 2, dropping the remainder).
Category
Engineering
Available in
Excel 2013+, Microsoft 365
Returns
A whole number
Overview
BITRSHIFT moves every bit a number of places to the right; bits that fall off the end are lost. Each place halves the value and rounds down, so shifting 13 by 2 gives 3.
A negative shift amount moves the bits left instead.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | A whole number from 0 to 2^48 − 1. |
| shift_amount | Yes | How many places to shift, up to 53 either way. Negative shifts left. |
Examples
Example 1 — How the bits combine
Each row combines the two numbers bit by bit; the answer is shown as an ordinary decimal number.
| A | B | C | |
|---|---|---|---|
| 1 | Number | Shift | Result |
| 2 | 13 | 2 | 3 |
| 3 | 16 | 4 | 1 |
| 4 | 100 | 1 | 50 |
| 5 | 3 | -2 | 12 |
Example 2 — Is switch 2 on?
Shift the switch you want into the last place, then keep just that bit.
| A | B | C | |
|---|---|---|---|
| 1 | Person | Code | Approve on? |
| 2 | Ana | 13 | 1 |
| 3 | Ben | 3 | 0 |
| 4 | Cy | 7 | 1 |
Common mistakes
- #NUM! Both numbers must be whole numbers from 0 up to 2^48 − 1 (281,474,976,710,655). Negative numbers, decimals and bigger values return #NUM!.
Notes
- Permission flags are a classic use: give each option a power of two (View = 1, Edit = 2, Approve = 4, Admin = 8) and store a person's access as one number — 13 means View + Approve + Admin.
- Related functions: BITLSHIFT, BITAND, QUOTIENT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.