Question

Using Excel build a decimal to 8-bit binary converter.

do not use any excel function except for IF.

Answer 1

Decimal notation describes numbers using the digits 1 through 10. Binary notation describes them using just two digits, 1 and 0, where each bit in a string represents a power of 2. The right-most bit represents 2 raised to the power of 0, the next right-most bit represents 2 raised to the power of 1, and each remaining digit represents double the previous one's quantity. Microsoft Excel converts from binary to decimal notation using the BIN2DEC function and from decimal to binary using the DEC2BIN function.

1. Type "=DEC" without quotes in an Excel cell. A drop-down box will prompt you to select DEC2BIN, DEC2HEX or DEC2OCT. Tooltip text will state that DEC2BIN "Converts a decimal number to binary."

2. Click "DEC2BIN," the first of the three options. Tooltip text will prompt you to enter arguments in the form of "DEC2BIN (number, [places])."

3. Enter the number you wish to convert. For example, if you want to convert 100 to binary, type "100" without quotes.

4. Type a comma.

5. Enter the number of bits you wish your binary number to contain. The number may append a string of 0's to the 1's and 0's necessary for expressing the figure. For example, if you want your binary number to contain eight bits, which is the number of bits in a byte, type "8" without quotes.

6. Press "Enter." The binary number will appear. With this example, Excel will display "01100100." The initial zero does not affect the number's magnitude, but it completes the byte.

Note : Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

Decimal	Binary
0	0000
1	0001
2	0010
3	0011
4	0100
5	0101
6	0110
7	0111
8	1000
9	1001
10	1010
11	1011
12	1100
13	1101
14	1110
15	1111