iQQ
New Member
- Joined
- Mar 1, 2021
- Messages
- 2
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
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)
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)