+ Reply to Thread
Results 1 to 2 of 2

Calculate item costs

  1. #1
    Registered User
    Join Date
    09-07-2008
    Location
    Essex
    Posts
    1

    Calculate item costs

    Hi there,

    this is my first post, cause I really need your help out there.

    I am trying to put together a sheet to calculate item cost after shipping and taxes. To be honest I may have complicated the whole thing but what I have is two

    order volumes that need to be changed to calculate the most cost effective solution.
    For example: Item 1 (a1) is $40 and item 2 (a2) is $10, if I was to order 100 (a3) of (a1) and 50 (a4) of (a2), then multiply them in (a5) and (a6) to give me total

    order values without taxes etc. I then have (a7) which is the shipping (a8) the import tax and (a9) the VAT.
    What I am stuck on is how to work out how much a1 and a2 costs me per item, if I was to order 100 of each then I think it would be simpler by calculating

    the total cost and divide by 100 then again by 25% which is the cost difference between $40 and $10. So although I may have gone around the houses on this

    one, I want to be able to change cells a3 and a4 and then see how much it is costing per item after shipping and taxes.
    Thanks for looking.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    invisible_hawk,

    Welcome to the forum. Please take 5 mins to read the forum rules below and then add the link to the other forum

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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. Merging data using unique column identifier?
    By jjinca in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 05-14-2013, 07:55 AM
  2. Calculate percentage of item in drop-down list
    By ttianna in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2008, 03:21 PM
  3. Formula to calculate number of cells with same data
    By tahirfayyaz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2007, 05:53 AM
  4. dropdown lists
    By szermat in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-16-2007, 05:08 AM
  5. Designing a formula to calculate western Union fees and shipping costs
    By MASTERforge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2007, 03:29 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