Reverse Formula.

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,174
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))))
 

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,174
Woaww, I'm very impressed, I dont know how you do this but you are amazing, It works perfect.

Thank you so much.
Serge.
 
Last edited:

Forum statistics

Threads
1,077,822
Messages
5,336,564
Members
399,088
Latest member
Swindlestikz

Some videos you may like

This Week's Hot Topics

Top