Who knows formulas for Microsoft Excel?

Question

I want to divide one column of data by another and have it inputted in the third column. I can do it one at a time but I'd rather save time.

Answer 1

Copy the formula from the 3rd column cell that you have already done. Then highlight the entire 3rd column and paste.

Answer 2

Start inputting the formula in single cell (the very topmost cell of Column C)
This formula would be: =A1/B1 which means the cell A1 (Column A, Row 1) will be divided by B1 (Column B, Row 1).

Press ENTER to get the result.
Check if it's correct.

Now, to get the result of the next row you can copy the formula on C1, and paste it on C2, and C3, and so on and so forth.

However, because Excel is pretty powerful tool you can use the filling method. How? Select C1 or the topmost cell with the formula. You should see the point at the lower right corner of selection box. Place the cursor/arrow over it until it turned into "+" and hook it there; drag it down and voila! you have just copied the formula and have obtained the results.

Check by selecting one result cell. The formula should appear
in the formula or input bar above it as: =A6/B6 if you've selected C6.

Also try manipulating your data using functions (f) -also in input/formula bar. Explore excel...

Answer 3

The foward slash is divide and the * is multiply. check out the help section, it is really useful. There should be a tutorial that you can go through. This would give you practice and help a lot. I love Excell. I do a lot of things on it. For the first row, highligh box c1 ant type the =a1/b1 then hit enter. This will automatically put the answer in c1. This will make row a column 1 get divided by row b column 1. Just repeat the process throughout. Just remember what row and column you are on. and always put the = sign first.

Good luck.

Answer 4

on Excel's latest version:

Go to C1 and type:
=A1/B1
press enter. The division will be performed and C2 will be selected.
Select C1 again, and at the lower-right corner of the C1 cell you'll have a "node" (where the mouse cursor will change to a black bold "+" sign), click-and-drag from there, until the end of the column. That will "autofill" your formula through the range of cells in the column.
It's important to understand that the autofill function copies the divisions relatively to the values in the respective row (horizontally). If you wan everything divided by a single value you need to add "$" signs at the divisor's cell definition:
=(A1/B$1$)

Answer 5

on the first row in the 3rd column do the formula that will divide column 2 by columb 1 (or vice versa) (i.e. =a1/a2) and then right click, copy, highlight all of the remaining rows in column 3, paste.

Answer 6

There is no need to start with multilication first. In the cell where you want the answer enter: = (E3 - (D3*38.46))*20% This is exactly an Excel interpretation of what you have written as your requirements. I trust that you realise that this will give a negative answer: You have gross pay $100.00 from wich you subtract 4*38.46 = 153.84 giving an intermediate result of 100.00 - 153.84 = -53.84 now you take 20% of this which is - 10.768 That is what the formula above will also return. Have you given us the logic of what you are wanting to do, properly. You must also learn to use brackets in your Excell formulas.

Answer 7

Let's say you want A1 / B1 to show in cell C1

Select C1and input ==> =A1/B1 <==

Now press enter and then return to cell C1

Look at the bottom right hand corner of the cell and see the little black square part, click and hold on that and drag the cursor down the page. The formula will be replicated correctly to all cells.

Answer 8

so you want to devide column A by Col B and put the result in C. It coudn't be easier.

1) Click in C1, and type an equal sign,
2) Click on A1 (which will put A1 in the fomula bar)
3) type a forward slash for divide "/"
4) Click B1 and hit enter
5) highlight all the rows in col C that you want to fill in with that formula
6) After you've highlighted hit Ctrl+D (for fill Down)

You're done!

Answer 9

you can divide one column by another even if located in third column by simply putting formulas in the last column or end column in your data. example =sum(E14/E16) if is located in Column E and Row 14 then Divided in COlumn E Row 16.

Answer 10

Highlight the third column where you have your formula and hit ctrl D

The formula should copy itself all the way down.