← Prev in month
← Prev in thread
Next in thread →
Next in month →
Re: [office-comment] BASE(): support two's complement negativebinary numbers
From: >Two's complement requires knowing the integer memory size. For example, the 8 bit two's complement number equivalent to -1 is 0xFF, but if that is a 16 bit number, then that is 255. > >How does BASE know the integer size for determining what the two's complement is? > >The machine size would give different results if a the spreadsheet is on a 32 bit machine or a 64 bit machine. BASE() has an optional parameter: 'Integer MinimumLength' that can be used to specify the bit size of the machine word for negative numbers. Valerio
← Prev in month
← Prev in thread
Next in thread →
Next in month →