Question: Using Excel, build a decimal to 8-bit binary converter. Do not use any Excel functions except for IF. Hi! I'm doing an assignment where i

"Using Excel, build a decimal to 8-bit binary converter. Do not use any Excel functions except for IF."

Hi! I'm doing an assignment where i have to make a decimal to 8 bit binary converter. How it should work is that when a decimal number is typed into A5, the numbers in B3 through I3 should change in accordance to the binary for that number, without using any functions other than the IF function. For example, typing 46 in A5 should make the binary become 00101110. I just can't figure out the formulas for it! I'd appreciate any help :) "Using Excel, build a decimal to 8-bit binary converter. Do not use

Clipboard Font Alignment Number A5 X for F G H 1 2 Bit # 7 6 5 4 3 2 1 0 0 0 3 0 0 0 0 0 0 4 Decimal # 5 0 Oo oo 9 10 11 -12 13 14 15 16 17 18 79

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!