Doubling formula that won't double the original number but itself.

[iQQ]

Hello all I am trying to figure out a way to make a formula that can double by a set number without doubling the original number but doubles itself each time.

FOR EXAMPLE.


so say A2=1,000,000 I need B2 to be the # of times it doubles itself by.

A2=1,000,000, B2=1, C2=1,000,000 (1,000,000)

B2=2, C2=2,000,000; (1,000,000x2)

B2=3, C2=4,000,000; (2,000,000x2)

B2=4, C2=8,000,000; (4,000,000x2)

B2=5, C2=16,000,000; (8,000,000x2)

B2=6, C2=32,000,000; (16,000,000x2)

B2=7, C2=64,000,000; (32,000,000x2)

B2=8, C2=128,000,000; (64,000,000x2)

 

[mart37]

=(A2*2)^(B2-1)

 

[iQQ]

=(A2*2)^(B2-1)

for some reason that gives me numbers that are much too large. Perhaps I am using the wrong option? SUM?

 

[mart37]

sorry i wanted my post deleted.

 

[mart37]

=2^(B2-1)*A2