:BITRSHIFT function calculates the value shifted to the right-Table skills免费ppt模版下载-道格办公

BITRSHIFT function calculates the value shifted to the right

Picture and text skills
Case

Returns the value shifted to the right by the specified number of digits.

Grammar

BITRSHIFT(number, shift_amount)

number must be greater than or equal to 0.

Shift_amount must be an integer.

Description

￭ Shifting the number to the right is equivalent to moving the number from The binary representation of a number with the digit removed from the rightmost side. For example, shifting the decimal value 13 to the right two places will make it binary

The value (1101) is converted to 11 (which is the decimal value 3).

￭If Number is greater than (2^48 )-1, BITRSHIFT returns the error value #NUM!.

￭If the absolute value of Shift_amount is greater than 53 , BITRSHIFT returns the error value #NUM!.

￭If any parameter is non-numeric, Then BITRSHIFT returns the error value #VALUE!.

￭If a negative number is used as the Shift_amount parameter , will shift the number to the right by the corresponding number of places.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/BITRSHIFT-han-shu-ji-suan-shu-zhi-you-yi-de-shu-zhi.html