Fwd: Howto: Excel does binary/octal/hex/dec conversions

[Ernst denBroeder]

Just passing this on...  maybe someone will find it useful.

Ernst



>Subject: Howto: Excel does binary/octal/hex/dec conversions
>
>To the propellerheads:
>
>If you're trying to evaluate some algorithms, and want to use Excel for 
>calculating rounding errors and what not, you may find it handy that Excel 
>can do:
>DEC2BIN(123)=1111011
>DEC2HEX(123)=0x7B
>DEC2OCT(1)=1
>HEX2BIN("A3")=0x111010 (note the quotes, without quotes it uses contents 
>of cell A3 )
>or any combination of DEC/BIN/HEX/OCT (BIN to 10 bits only, read help)
>
>To enable these functions, all you have to do is open the menu 
>Excel->Tools->Addins, and check off "Analysis Toolpack" provided it is 
>installed on your machine.
>
>have fun...
>Andre
>ps. actually found these functions handy while working at Lockheed on a 
>1960's era one's complement computer (octal to boot)...sigh the good old 
>days where (-1)+1=minus zero....    :-)


----------------------------------------------------------------------------
To unsubscribe from gmecm, send "unsubscribe gmecm" (without the quotes)
in the body of a message (not the subject) to majordomo at lists.diy-efi.org