Results 1 to 4 of 4

Help with creating simple product formula from column to column for each row.

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2013
    Location
    Alabama
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help with creating simple product formula from column to column for each row.

    Hello,..

    I want to simply have the cells in one column be the product of cells in two other columns, and have the whole spreadsheet do this at the same time without having to put the formula into every single cell.

    Example: I have a column with a quantity of an Item (column D). I have another column with the price of each item (column E). I want column (F) to be the product of column D and column E per each Row,.. i.e., 5 items (column D, row 8) x $2.00 (column E, row 8) = $10.00 (column F, row 8). uugghhh!! This just be soo simple, yet I can't find the answer anywhere,..

    Thanks in advance for any help you may be able to offer,...


    Kindly,

    Brett
    Last edited by flyndad; 09-01-2013 at 06:26 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Should be Simple? .Find - Numbers Only?
    By neghsmoke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2012, 07:09 PM
  2. Simple Find Values?
    By James_C in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-06-2009, 08:51 AM
  3. Simple Vba to find a date
    By Algeraist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2008, 04:59 AM
  4. need to find simple sum %
    By phat al in forum Excel General
    Replies: 2
    Last Post: 02-08-2007, 01:11 AM
  5. simple find
    By tcpteacher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2005, 10:05 AM

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