Re: Adding and Multiplying Question
The formula you want in column "I" is as follows
Assuming you begin with row 1 and that the order
of operations is as you have written:
=E1+F1*D1
If you actually want to multiply the sum of columns
E and F times column D, the (E1+F1)*D1
To apply this to every row, click on the tiny black box
on the bottom right of the cell with the above formula
and drag down to row 260.
.
Relevant Pages
- Re: Automatically number rows preceded by text
... Click on the little black square at bottom right corner of cell A1 ... Drag down ... I apologize if this question has been asked in the past. ...
(microsoft.public.excel) - Re: the drag feature in combining cells wont work
... bottom right corner of the cursor, and double-clicking it will copy the ... Pete, thanks for the answer, but I still can't get the drag feature to ... like D2 I get nothing but a blank cell all the way down the column. ... highlight and drag and it will do it for you. ...
(microsoft.public.excel.worksheet.functions) - new to excel
... Now Click the little black box in the bottom right of the ... cell and drag the formula down as many lines as you like. ... >find an answer in references that I am using and I am ...
(microsoft.public.excel.worksheet.functions) - Re: Automatically number rows preceded by text
... Click on the little black square at bottom right corner of cell A1 ... Drag down ... I apologize if this question has been asked in the past. ...
(microsoft.public.excel) - Re: Changing a word document into an excel spreadsheet
... After you paste the info into EXCEL, Select ALL of Column A or whatever ... Column you pasted the text into (do not select Cell A1 and DRAG down) ... Prev by Date: ...
(microsoft.public.excel.misc) |
|
