Excel 2007 : IF statements with 3 values

[Rooster35236]

I'm trying to put together an if statement with Multiple values and far too complicated criteria
Thanks to everybody for all the help so far!

[Marcol]

What are you testing?

Did this thread help you to understand IF functions.

http://www.excelforum.com/excel-gene...-r2-d2-r2.html

Your solution will probably involve nested IF functions.

[Rooster35236]

Ok, This an an excerpt of the sheet i'm working with, essentially what i'm trying to do is tabulate the final value fees up front when i'm setting my prices. but ebay makes it very complicated. see my attached spreadsheet and the word doc that lists the ebay final value fees.

So what i'm trying to do is:

using p5 row5 as my example:

if j5 is yes or no i need it to run the corresponding formula whether its for auction which is a standard 9% or the fixed price which then i would need it to ask if g5 is electronics, clothing, books or other, then find out the sold price in L5 and subtract the various ebay %'s. If it makes it any easier I'll never sell anything for over $1000.
Or is this just entirely too much tabulation for a single core cpu and if i ever manage to get the formula completed it will just blow my processor right through the keyboard. lol

[JulieM]

To work out your ebay fee, including over £1000 items, the basic calculation is:

Please Login or Register  to view this content.

)

Where 0.08, 0.05 and 0.02 are the rising % for the electronics category.

I would use a vlookup to find the appropriate % for the different categories, so you'd have a table something like

Please Login or Register  to view this content.

The figure 0.02 is the same for all categories so doesn't need a lookup.

HTH