Results 1 to 3 of 3

Thread: What is the best formula to use

  1. #1
    Neophyte imran999's Avatar
    Join Date
    Mar 2018
    Location
    Sydney
    Posts
    3
    Articles
    0
    Excel Version
    2013

    Question What is the best formula to use



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,
    I am seeking assistance with attached file to best apply formula to calculate amount to be charged using a basic and per kg rate structure. Basic and Per Kg is based on certain criteria in col A-D in order of first match application. To illustrate, i have used iferror/vlookup (can this be enhanced). I am also wondering if index match/sum product would be a better way to go about this and how to apply this?
    Attached Files Attached Files

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,336
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi and welcome
    could you please indicate where the desired result should be?
    Thank you Ken for this secure forum.

  3. #3
    Neophyte imran999's Avatar
    Join Date
    Mar 2018
    Location
    Sydney
    Posts
    3
    Articles
    0
    Excel Version
    2013
    Col E & F

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •