base conversions

Posted by John on July 22, 2001 7:52 PM

I would like to know how to change the base of a number eg decimal to binary and how to make binary calculations like plus minus multiply division all within an excel spreadsheet

Posted by Mark W. on July 23, 2001 6:31 AM

See DEC2BIN() and BIN2DEC() worksheet functions.
If these functions are not available, run the
Setup program to install the Analysis ToolPak.
After you install the Analysis ToolPak, you must
enable it by using the Add-Ins command on the
Tools menu.

Posted by AB on July 23, 2001 7:04 AM

Just a side note...

Mark is correct in his suggestion for using those functions. However, the Dec2Bin and Bin2Dec functions will only work for up to 10 bit conversions. They should have expanded it to cover at least up to 16 bit.

I have some boolean algebra and higher than 10 bit coversion examples (building your own conversion tables) on my website for anyone interested in seeing how to bypass the binary conversion formula limitations in Excel.

Just look for the "Logic_Gate" example file in the formulas & logic section.

Regards,
AaronThe Excel Logic Page