Any EXCEL experts

  Chrissib 11:05 23 Jul 2009
Locked

I am trying to substitute values in excel to populate multiple values, by using calculations from the initial value.
for example x to be input manually

I want to
add (x)
add (x+2)
add (x+4)

by inputting x, want the other cells to update..
so x = 4
add 4
add 6
add 10

I cant find a formular which will do this.

  VoG II 11:28 23 Jul 2009

In A1 enter a number

In A2 enter

=A1+2

Click in A2, hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag down as far as needed.

  Chrissib 09:37 28 Jul 2009

Simples... Thanks

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Best of the Grad Shows 2017: UAL Central Saint Martins

MacBook Pro 15-inch (2017) review

Comment connecter un MacBook à une TV ?