[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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