+ Reply to Thread
Results 1 to 2 of 2

Adding and Multiplying Question

  1. #1
    John Bordieri
    Guest

    Adding and Multiplying Question

    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



  2. #2
    mrtoemoss@hotmail.com
    Guest

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1