Suppose I have a list of names in column A. In B and C I have numbers, and in D I want the ratio of B/C. How do I set up D so it calculates that ratio for every single row once I manually input B and C for that row?
Write "=B1/C1" into D1 and then drag the bottom corner of the highlighting of the square down to the end of the data. If you do it right every D square will have "=Bn/Cn" in it where n is the row of the square.
Originally posted by XanthosNZ Write "=B1/C1" into D1 and then drag the bottom corner of the highlighting of the square down to the end of the data. If you do it right every D square will have "=Bn/Cn" in it where n is the row of the square.
