Engineering

BITLSHIFT Function in Excel

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

Syntax

  • =BITLSHIFT(number, shift_amount)

Arguments

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

Examples

  • =BITLSHIFT(4, 2) - Shift 4 left by 2 bits - Result: 16

BITLSHIFT 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
  • Multiplication by powers of 2
  • Programming

Frequently asked questions

  • What is the BITLSHIFT function in Excel? BITLSHIFT returns a number shifted left by the specified number of bits. The syntax is =BITLSHIFT(number, shift_amount). Typical use cases include bit manipulation, multiplication by powers of 2, programming.
  • How do I use the BITLSHIFT function? To use BITLSHIFT, type =BITLSHIFT( 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 BITLSHIFT not working in my Excel? Common issues with BITLSHIFT include #NUM! if shift_amount < 0. Start by checking the syntax =BITLSHIFT(number, shift_amount), then verify each referenced cell or range.

Editorial review

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