calculate % discount for full column

Hi all,
sorry if you all think this is a stupid question but I have never used excel before. I am trying to create a formula for a column that will display a total with discount misused. I can do the calculation for each individual row, but don't know how to do this for the column as the price and quantity of each item changes on every row. I have an item price column, quantity and a discount column (30% discount deducted). The calculation for the row looks like this =(F3/100*70). As I have many rows I would like a calculation for the full column.
Thank you in advance guys
Regards
Jordan T

Just copy the formula down.

Or, if the discount is different in each row, use something like

=(F3/100*X3)

where column X holds the discount value for that particular row.

Jordan, just copy the formula down.

select the cell with the formula. Hold down the Shift key and use the down arrow key until you have selected all cells where you want the formula to go. Then hold down the Ctrl key and hit D (for "copy DOWN").

There are half a dozen other ways of copying a cell/formula down a column (or across a row). Read up in the Excel help how to perform such basic operations.

The core matter is that you only have to write a formula once, then you copy the formula down the column (or across the row). The cell references will adjust in each row, if you use relative references. So, if in row 3 you have the formula

=(F3/100*70)

and you copy it down a few rows, you will see in row 4 that the formula shows

=(F4/100*70)

and in row 5 it reads

=(F5/100*70)

and so on.

Does that work for you?

Jordan,

if you use an Excel 2007 table (Insert - Table), then you can enter a formula in the first data row of the table and it will automatically be applied to the whole column.

If you don't use a table, you will need to copy the formula to the respective cells with any of the going methods used for copying cells.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save