计算公式:
=IF(HEX2DEC(DEC2HEX(AG108693))<2147483648,HEX2DEC(DEC2HEX(AG108693)),HEX2DEC(DEC2HEX(AG108693))-4294967296)
例如 AG108693为原始数据,计算得到AF108693输入如下:
计算公式:
=IF(HEX2DEC(DEC2HEX(AG108693))<2147483648,HEX2DEC(DEC2HEX(AG108693)),HEX2DEC(DEC2HEX(AG108693))-4294967296)
例如 AG108693为原始数据,计算得到AF108693输入如下: