Adding and Multiplying Question

[John Bordieri]

Hi,

I have an inventory spreadsheet and I am trying to figure out how to add
column "E" and column "F" then at the same time multiply column "D" to get a
total in column "I".

E F D I
ie: 5+2*10=70

Then how do I apply this to every row (there are 260 rows) without typing
the formula in for each row?

Thank you,
John

 

[mrtoemoss]

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.