![]() ![]() ![]() He shifts everything by a power of two (2^31 in his case) to use the 2's complement: =BASE(2^31+MyNum, 2) Negative numbers: Come to think of it, negative numbers could be handled as well by building upon howy61's answer. Here are some examples: =BASE(3,2) # returns 11 For positive numbers only, just use BASE (as in BASE2) for numbers between 0 to 2^53 in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |