Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Pa, Pennsylvania, USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Address dip switch settings (Excel 97)

    I don't think I have seen anything like this before so here goes the question:
    I need to use an Excel spreadsheet to generate a BCD coding.
    Example: Switch 8 7 6 5 4 3 2 1
    0 1 1 0 1 0 1 1 equals 107 (line up the zero's and one's under the switch settings)
    I will attach a file with the columns set up but I am at a loss for figuring out how I will do this.
    Thanks in advance,

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Address dip switch settings (Excel 97)

    Does the attached do what you want?
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    New York, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Address dip switch settings (Excel 97)

    Use Bin2Dec and Dec2Bin functions. You will have to have the Analysis Toolpack Add-In loaded.

    HTH
    Thom

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Pa, Pennsylvania, USA
    Posts
    122
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Address dip switch settings (Excel 97)

    Yes, it does. Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •