Reverse Formula.

[serge]

I'm looking for a reverse formula that will give me back the number of the beginning meaning :

0212010 would give me back 2436 ? in cell : R8

Q8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/1),4))))
P8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/4),4))))
O8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/16),4))))
N8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/64),4))))
M8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/256),4))))
L8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/1024),4))))
K8 =IF($I8="","",INT(LEFT(MOD(SUM($H8/4096),4))))

 

[Tetra201]

Try

=SUMPRODUCT(K8:Q8*4^{6,5,4,3,2,1,0})

 

[serge]

Woaww, I'm very impressed, I dont know how you do this but you are amazing, It works perfect.

Thank you so much.
Serge.