Forum Discussion

Tapster's avatar
Tapster
Copper Contributor
May 29, 2020
Solved

Decimal to Binary

I am trying to create a spreadsheet that takes an Decimal IP address and populates individual cells within the octets with the binary value equivalents. I need to keep a running value total based on ...
Need Help
Tutorial
  • Tapster's avatar
    Tapster
    May 29, 2020

    Jos_Woolley 

    Thanks for this. It worked like a champ. Can you direct me to where I could read a bit about what the +0 is doing for me.

    Have a great weekend and again, thanks.

    TAPS

Tapster's avatar
Tapster
Copper Contributor
May 29, 2020
I spoke to soon. Cells B8:B9 are populated with the MID function. The value in both cells is 1. I run an AND on the two cells and get an error that "A value used in the formula is of the wrong data type". I was feeling good for a bit and I did find Wyn's video to answer my other question.
  • Tapster's avatar
    Tapster
    Copper Contributor
    May 29, 2020

    Tapster 

    Spreadsheet attached with error shown on Net ID page cell B11.

    Any thoughts, recommendations, assistance appreciated.

    • Jos_Woolley's avatar
      Jos_Woolley
      Iron Contributor
      May 29, 2020

      Tapster 

       

      MID returns a text value, not a numeric. Either coerce your results from MID to numerics viz, for example (cell B8):

       

      =MID(AL5,1,1)+0

       

      else leave them as text and amend your checking formula (cell B11) to:

       

      =AND(B8+0,B9+0)

       

      Personally I'd prefer the former option as working with numerical 0s and 1s is both more logical and practical.

       

      Regards

      • Tapster's avatar
        Tapster
        Copper Contributor
        May 29, 2020

        Jos_Woolley 

        Thanks for this. It worked like a champ. Can you direct me to where I could read a bit about what the +0 is doing for me.

        Have a great weekend and again, thanks.

        TAPS

Resources