Copy the formula in A4 to the remaining cells in the range (A5:A34 for our example data set). As you can see in Figure E , the formula returns a column of 1s and -1s.