[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] BASE(): support two's complement negativebinary numbers
From: jjcogliati-whatwg@yahoo.com >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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]