For any bit shift that results in integer overflow, where the result is larger than 2^48 -1, the function returns the #NUM! error.
The shift_amount can either be positive or negative. If a negative number is provided, the bits are shifted to the right instead.
Get over 100 Excel Functions you should know in one handy PDF.
Quick, clean, and to the point.