element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • About Us
  • Community Hub
    Community Hub
    • What's New on element14
    • Feedback and Support
    • Benefits of Membership
    • Personal Blogs
    • Members Area
    • Achievement Levels
  • Learn
    Learn
    • Ask an Expert
    • eBooks
    • element14 presents
    • Learning Center
    • Tech Spotlight
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents Projects
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Avnet Boards Community
    • Dev Tools
    • Manufacturers
    • Multicomp Pro
    • Product Groups
    • Raspberry Pi
    • RoadTests & Reviews
  • Store
    Store
    • Visit Your Store
    • Choose another store...
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
  • Settings
Learning Center
  • Learn
  • More
Learning Center
Blog How to build and work with Logic Gates using MS Excel (2)
  • Blog
  • Documents
  • Polls
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Join Learning Center to participate - click to join for free!
  • Share
  • More
  • Cancel
Group Actions
  • Group RSS
  • More
  • Cancel
Engagement
  • Author Author: backcorp
  • Date Created: 29 Nov 2020 9:16 AM Date Created
  • Views 895 views
  • Likes 0 likes
  • Comments 0 comments
  • logic gate project
  • logic gates
  • logic gates ms excel
Related
Recommended

How to build and work with Logic Gates using MS Excel (2)

backcorp
backcorp
29 Nov 2020

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.

Attachments:
1602.SPDT Switch.xlsxSPDT Switch.xlsx
  • Sign in to reply
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2025 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • X
  • Facebook
  • linkedin
  • YouTube