How to devide column B on column A in excel?

Question

I have a column of numbers in column A, next to it column B :) I would like to devide column B on column A and have results posted in column C. Formula =Column(B)/Column(A) doesnt work. Is there a simple way of getting result in column C without entering formula per cell.

By the way, you all Rock! this is so cool I never used this before, until today.

Answer 1

lets say you have 20 sets of numbers A1-A20 & B1-B20.

In C1 enter =B1/A1 and Press the enter key that should show the divedend in C1.

To copy the formula in the other 19 cells: click on C1 and move the arrow to the bottom right corner of the cell. The arrow should transform into a plus sign(+) with a little dark square on the lower right hand corner of the cell. Left click the mouse and hold, pull the little dark square down to C20. That will copy and adjust the formula per cell from C1-C20.

Your done...

Answer 2

I don't exactly know what you mean; there could be two things that you want.

If you want every cell on column C to equal column B on the same row divided by column A on the same row then follow these instructions:

1. Type '=B1/A1' into cell C1.
2. If A1 is empty (Or 0), then it will give an error, so change the forumula to '=ONERROR(B1/A1,"")'.
3. Copy the cell.
4. Select cell C1.
5. Hold the control key and press down.
6. Press CTRL+V, this may take a while to load, or it may be instant, depending on your computers capabilities.

If you want cell C1 to be the result of every value on column A divided by every value on column B, then follow the following instructions:

1. Hold the control key and press down.
2. Remember the number of rows (This depends on the version of Excel).
3. Type '=ONERROR(SUM(A1:A)/SUM(B1:B)',"") into cell C1.
4. 'ONERROR' is there, to prevent any errors from occurring, if the values are empty.
5. Replace '', with the amount of rows in your Excel sheet.

I hope all this helped.

Answer 3

Column A Column B

Answer 4

Hi,
Suppose column A's cell address is A1
Suppose column B's cell address is B1
Suppose column C's cell address is C1
u want ur result in C1
write in C1 (as u have written)=A1/B1
now copy this (=A1/B1) formula in other cells of column C, u will get the desired result. or after writing the formula, drag this cell down, u will get the formula pasted in other cells(i.e. c2, c3, c4, c5... )

Answer 5

hurry up guys