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!
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!
Last edited by Rooster35236; 11-21-2010 at 01:21 PM.
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.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
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
Last edited by Rooster35236; 11-21-2010 at 01:25 PM.
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
The figure 0.02 is the same for all categories so doesn't need a lookup.Please Login or Register to view this content.
HTH
Last edited by JulieM; 11-22-2010 at 07:45 AM. Reason: missed the bracket out of the code tag!
I count on Excel for everything
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks