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 manuallyI want to add (x)add (x+2)add (x+4)by inputting x, want the other cells to update..so x = 4add 4add 6add 10I cant find a formular which will do this.
In A1 enter a numberIn A2 enter=A1+2Click 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.
This thread is now locked and can not be replied to.
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 ?
© Copyright 2017 IDG UK. All Rights Reserved.