Results 1 to 10 of 10

Freight Allocation

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    Freight Allocation

    Hello everyone, Thanks for looking at my thread. I need some help on the attached file. I have invoice number on column A. There are a lot of different items on each invoice. Some of them has freight charge, some not. All different items has different cost. I need to come up with a formula (column E) that allocate the freight cost (column D) to each item based on the item cost (column B).

    I hope I explain it well enough.

    Thanks,

    Jackson
    Attached Files Attached Files
    Last edited by jackson_hollon; 05-26-2017 at 03:57 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Please Help - Freight Matrix Needed
    By gillymore in forum Excel General
    Replies: 1
    Last Post: 12-11-2016, 11:29 PM
  2. Freight Rate Repository
    By gpalis in forum Access Tables & Databases
    Replies: 3
    Last Post: 04-14-2016, 12:17 AM
  3. Freight Calculator
    By kushalbilala in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-19-2013, 10:07 AM
  4. [SOLVED] Freight calculator
    By someko in forum Excel General
    Replies: 8
    Last Post: 01-22-2010, 09:55 AM
  5. Freight Calculator
    By o'h3nry in forum Excel General
    Replies: 15
    Last Post: 01-21-2010, 10:52 AM
  6. how to analyze freight expense?
    By Vasant Nanavati in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  7. how to analyze freight expense?
    By boots in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02: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