+ Reply to Thread
Results 1 to 2 of 2

Need to add formula for extended price

  1. #1
    Registered User
    Join Date
    12-13-2014
    Location
    Tracy
    MS-Off Ver
    2010
    Posts
    1

    Need to add formula for extended price

    Hi all,
    Excel noob here. I need to create a formula to multiply the quantity (column F) by the unit price (column G) to create an extended price (column H). Can anyone help with that being as rookie proof as possible?
    Thanks.
    By the way, first post ever on forum!

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Need to add formula for extended price

    Hi and welcome

    Have you simply tried in Column H - say H1 if your data starts in row 1, = F1*G1 and copy this down column H.

    If you have some row headers in row 1 then type this formula in row 2 or row 3 as applicable and change '1' to '2' or '3' accordingly before copying down
    Happy with my advice? Click on the * reputation button below

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 11-20-2014, 11:10 PM
  2. [SOLVED] Compare 1 price against multiple prices and change the price according to a formula
    By CharlieAziz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-16-2012, 11:05 AM
  3. Sum extended price without extended price column
    By kellyfspringer in forum Excel General
    Replies: 2
    Last Post: 07-14-2009, 09:45 PM
  4. Extended IF Formula
    By PenWool in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2008, 02:52 PM
  5. [SOLVED] create a formula for price * discount* tax =final price
    By anton in forum Excel General
    Replies: 6
    Last Post: 10-12-2005, 03:05 PM

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