How can I divide two columns and put the quotient in its own column? For example, I want all the cell in column Gx to equal Cx divided by Ex and all the cells in G need to be that way for their corresponding C and E. How can I do this without typing it for each cell individually??
2007-02-06 08:00:06 · 3 answers · asked by cashmaker81 6 in Computers & Internet ➔ Other - Computers
Just create the equation to divide C by E in the first cell G then copy and paste it in the selected cells for Column G for the remaining rows.
2007-02-06 08:12:39 · answer #1 · answered by Anonymous · 1⤊ 0⤋
Click in the first G cell you want the formula to appear in. Establish the formula by typing "=Cx/Ex", then copy it (Cntrl C) then highlight the range and hit Enter. That should do it.
2007-02-06 16:13:03 · answer #2 · answered by pckc1014 1 · 0⤊ 0⤋
message me at herochenna@yahoo.com
i will help you online
2007-02-08 09:38:55 · answer #3 · answered by Anonymous · 0⤊ 0⤋