Maybe someone will like this for its introduction to Excel spreadsheet formulas. I love Conditional Formatting. Its like the toy inside the toy.
FYI: I checked out the SPDT Switch I attached previously and somehow it lost all the formulas. I will attach the repaired spreadsheet to this one.
(Part 2 of 3)
Preparation for the Logic Gates.
Merge & Center [L1]&[M1]. Click on [C1], click on Format Painter and click back on [L1]. Type “INPUT”. Add “All Borders” to [L3],[L4],[M3]&[M4]. In [L3] type “A”. In [L4] type “B”. Click on [A2], click on “All Borders”.
Now we will do our first formula. In [A2] type “=rand”. A drop-down menu will appear. Double click on “RANDBETWEEN”. Located above the cells column letters you will see: = RANDBETWEEN. To the left of that you will see: ”fx”. Click on that to open the “Function Arguments” box. Type “1” for “Bottom” and “4” for “Top”. Click on “OK” at the bottom of the box.
Now click on an unused cell and hit the “F9” button at the top of your keyboard. Hit it a few times to see [A2] change.
The next formula is Choose. Click on [M3] and type “=cho”. Just like last time, double click on “Choose”, click on “fx” and fill out the drop-down box. This one is eazy, “Index_num” is “A2” or you can just click on [A2]. Hit your Tab key or click on the “Value 1” Box. These are your “A” numbers under your “STATES” box. “Value 1”: [C3] “Value 2”: [D3] “Value 3”: [E3] “Value 4”: [F3], Click on “OK” at the bottom of the box.
Now repeat this for [M4]. Use the same “index_num”: [A2] but the values will be your “B” numbers, [C4]-[F4]. Click OK and then “F9” a few times to see it work.
We could have simply put in “=(RANDBETWEEN,0,1) but now we have a way to somewhat fake a memory. An option that I used and may want again sometime.
I have a reminder in mine for the F9. If you want one click on [L1] then Format Painter and click on [H3]. Type “Hit F9” And change the color. Mine is light blue.
The preparation for the Logic Gates is complete now we can build them.