Excell Module

[Kein]

Hello,
I am a newbie to Excel VBA. Can anyone help me developed a module or function that will check the number of bits of a binary number and then calculate the resistance of a binary resistors in parallel combination. One column of excel sheet contains binary data to be checked i.e.
0000,0000,0000,0001
0000,0000,0000,0010
0000,0000,0000,0011
0000,0000,0000,0100
;
;
0000,0011,1111,1111
0000,0100,0000,0000

for example.
if binary number is 0000,1111
then the resultant of R0, R1, R2, R3 should be calculated i.e. Rs=1/R0+1/R1+1/R2+1/R3

The values of binary resistors in parallel are:
R0 R1 R2 R3 R4 R5 R6 R7 R8 R9 R10
1 2 4 8 16 32 64 128 256 512 1024

Appreciating your input in advance.
Regards,
Kein

[royUK]

Welcome to the Forum. You will get better responses if you choose the correct forum. I've moved this to the programming forum

Read all the rules before posting again

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.