[EXCEL] Need some help please

Play Now

Breezer

Legend
Legendary
Jul 16, 2004
3,684
845
345
Does anyone know how i can achieve the following...

LEVEL 150 = 312500000 (This is + 800k each level)
LEVEL 151 = 313300000

How can i make the 313300000 add 800k , then have the next one add 800k to the value counted before

So my next value would look like...

LEVEL 152 = 314100000

and so on , all im managing to do is add 800k to One value, instead of it adding it to the next value.
 

Ali3n

Golden Oldie
Golden Oldie
Apr 27, 2004
705
5
155
Leicestershire
A1 = 312500000
A2 = 313300000
A3 = 314100000

Highlight all 3, click and drag the black square in the corner down, it'll add 800k to each box going down.
 

Robert

Actual Jesus
VIP
Jan 1, 1970
4,652
97
104
Yes.
Or Just use a simple formula:

Type =A1+800000 and drag that down, as the A1 part isnt locked it will replicate it down. The 800000 is set and wont change.