Adding and Multiplying Question

  • Thread starter Thread starter John Bordieri
  • Start date Start date
J

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
 
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.
 
Back
Top