Results 1 to 6 of 6

Need formula for price based on quantity and product name on a separate sheet.

Threaded View

alepoutre Need formula for price based... 08-10-2011, 04:18 PM
ZENITH Re: Need formula for price... 08-10-2011, 04:23 PM
alepoutre Re: Need formula for price... 08-10-2011, 04:37 PM
ZENITH Re: Need formula for price... 08-10-2011, 04:41 PM
alepoutre Re: Need formula for price... 08-10-2011, 05:02 PM
ZENITH Re: Need formula for price... 08-10-2011, 05:06 PM
  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    5

    Need formula for price based on quantity and product name on a separate sheet.

    What I'd like to do is have it where I will enter a quantity in column 'D' on sheet 1, and column 'I' will automatically formulate a price based on quantity multiplied by the price per unit which is set to a corresponding style number on sheet 2. It would also have to take in account the style number on sheet 1 (column B) and make sure it matches the style number in sheet 2 (where it is in column A).

    I've attached an example with prices already filled in based on manual calculations. Can this be done? Any help would be greatly appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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