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 1's and 0's in order to calculate the next field. Everything I'm doing is circular and it's driving me nuts. For example, I'll take the first octet with the Decimal 152 for conversion.

=IF(B3/B6>1,1,0) and the cell populates a 1 (152/128>1)

I'm keeping a running total with

=SUMIF(B8:I8,"=1",B6:I6) and the field populates with 128 the first go. However, I can't use that cell as a running total because it's circular.

I'm going to bed but thought I'd see if anyone had a suggestion or tutorial recommendation I could review when I get back on this in the morning. I am aware that the =DEC2BIN(B3,0) will give me the binary value but it doesn't allow me to associate the power of two position that I am trying to stress in this lesson.

Hopefully this makes sense to someone.

Thanks in advance.

TAPS