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 200 Excel shortcuts for Windows and Mac in one handy PDF.
Quick, clean, and to the point.