Formula Problem

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

I need help with an inventory list where column b has the
quantity, collumn c has the price and in column D I would
like the product of b*c on the same row. How would i setup
if i want to multiply b*c on the same row all the way down
the page and have the total on D of every row.
 
If your headers are in Row1, and your data starts in B2 and C2, then in D2
enter:

=B2*C2

Now select D2 and place your cursor (fat white cross) over the tiny black
square that is in the lower right corner of the cell until it changes to a
skinny black cross.
Now, just double click, and your formula will be copied down Column D, as
far as there is data or formulas in Column C.

If Column C is not yet populated, then click and drag the skinny black cross
down Column D as far as needed to copy your formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need help with an inventory list where column b has the
quantity, collumn c has the price and in column D I would
like the product of b*c on the same row. How would i setup
if i want to multiply b*c on the same row all the way down
the page and have the total on D of every row.
 
Back
Top