+ Reply to Thread
Results 1 to 2 of 2

Need an IF/Then Statement for Calculating Orders

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    Murray, Kentucky
    MS-Off Ver
    Excel Mac 2011
    Posts
    4

    Need an IF/Then Statement for Calculating Orders

    I have a workbook to keep track of items ordered, quantity ordered and total cost for the order. I have columns for the item description and the quantity. Then I have a column for the price per piece for that item. The last column calculates the total cost for that item.

    I have about 40-41 items, each has it's own price per piece. I would like to be able to enter just the item and the quantity. Is it possible to have a formula (such as an "if/then" formula) that will automatically place the price per piece when I enter the item?

    I have attached a workbook with the four columns and the list of items with their price per piece. I have entered two "orders" as a sample.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Need an IF/Then Statement for Calculating Orders

    Put this formula in C2:

    =IF(COUNTIF(I:I,A2)=0,0,VLOOKUP(A2,I:J,2,0))

    then copy down as far as you need to.

    Hope this helps.

    Pete

+ Reply to Thread

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