Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Help (Office 97)

    Hi
    I am a bit stumped with this one I am trying to work out is it possible to have a formula in excel that takes all of the considerations listed below into account and totals the price for listing and selling an item. Assuming the item sells when it is listed for auction I would be very grateful if anybody could advice me of a formula which would work this one out for me.
    The charges are listed below
    Listng fees
    Item selling listed for

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (Office 97)

    The attached workbook should show you how to do what you want.
    Attached Files Attached Files
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Mar 2001
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (Office 97)

    Thankyou very much for youre kind assistance just what the doctor ordered I would have never worked the formula out for that on my own. What a great resource for excel help this site is
    Thanks again
    Graham

  4. #4
    vandenberg
    Guest

    Re: Formula Help (Office 97)

    Another way without using VLOOKUP and IF

    Listng fees
    = (Listng fees>0)*0,15+(Listng fees>5)*0,15+(Listng fees>15)*0,3+(Listng fees>30)*0,65

    Selling fees
    =(Selling fees<15)*Selling fees*5%+(Selling fees>15)*(Selling fees<600)*(Selling fees*2,5%+,375)+(Selling fees>600)*15,75

    HTH

    VANDENBERG
    BRAZIL

Posting Permissions

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