# Thread: Formula Help (Office 97)

1. ## 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. ## Re: Formula Help (Office 97)

The attached workbook should show you how to do what you want.

3. ## 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. ## 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
•