Latest Lists

How can I convert a function to list form in Excel ?

If I have lets say two columns, and I want column B to give whatever is in column A on that line divided by half, how can I put this into practice?

Public Comments

1. If the first column is column 'A' and the second is column 'B', then in the first cell in column 'B', type '=A1/2' (Without the apostrophe). Copy and paste to all of the other cells that you want the formula applied to.
2. In cell B1 put =A1 / 2 Make sure it gives you answer you want. So if it is 12 in A1 you have 6 in B1 Now highlight cell B1 and Copy it. Then highlight cells B2 down to where the data ends and Paste. Done!
3. The very first things you should know when using excel, after getting acquainted with the icons on the toolbars and what the formula bar is, is what the mathematical operators are, i.e. plus is +, minus is -, multiplication is * and division is /. Therefore to divide cells in column A by half would be = A1/2 and then autofill down.