Counting the (1) in a binary number.

[serge]

Hi,


I have a this formula in W1465 :

=RIGHT((DEC2BIN((MOD(U1465,4096)/512),3) & DEC2BIN(MOD(U1465,512),9)),7)


Which return the binary string of a number.


I'm looking for a formula in cell AB1465, that will count how many digits (1) are in that string ?


Thank you.

 

[r1998]

Hello serge

I'm looking for a formula in cell AB1465, that will count how many digits (1) are in that string ?

for that, use this formula

=LEN(AB1465)-LEN(SUBSTITUTE(AB1465,"1",""))

 

[serge]

Thank you so much r1998, it works perfect, I appreciate it.
Serge.

 

[r1998]

Thanks