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

[Ernst denBroeder <edenbroe@cisco.com>]

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@lists.diy-efi.org