EBAY SPREADSHEET

[yarnoss]

Iam trying to write a SPREADSHEET to manage my ebay auctions i have 8 columns
1=Purchase price of item : 2=Mark up (%) :3=List Price : 4=Gross Profit :5=End Price EBAY : 6=Final VALUE fee: 7=ship/h : 8= Net PROFIT :->
At the moment i have purchased a ebay calculator and i have to manually calculate every item individual and is very inefficient, i want to be able to manage all this thru EXCEL.

My QUESTIONS are when i enter the endprice for each auction item how do i automate the spreadsheet to enter the final value fee by iteself ? This is the commission i pay ebay which is a percentage of the endprice of the auction

ebay fees
:-> $0.01 - $19.99 / $0.35
:-> $20.00 - $49.99 / $0.75
:-> $50.00 - $99.99 /$1.50
:-> $100.00 - $399.00 / $2.50
:-> $400.00 and up /$3.50

All of column 7 (s/h) is pre filled i want to be able to enter the end price from the auction and the spreadsheet to calculate the ebay fees and the net profit from my Purchase price??
Can somebody out there give me directions please!!!!

 

[Brian from Maui]

Try this,

Book1
	A	B	C	D
1			End	End+Comm
2	$0.01	$0.35	$20.00	$20.75
3	$20.00	$0.75
4	$50.00	$1.50
5	$100.00	$2.50
6	$400.00	$3.50
Sheet1

 

[Txtaz6763]

Yarn, have you checked on the eBay discussion boards?

I believe I've seen someone with a SS that uses this formulation over there.

Lisa

 

[Ahnold]

If EndPriceEbay is in E2 then F2 = =IF(E2<=19.99,0.35,IF(E2<=49.99,0.75,IF(E2<=99.99,1.5,IF(E2<=399.99,2.5,3.5))))

 

[Mark F]

I have a Worksheet which is valid for UK Ebay Fees, but could be easily amended for use in other countries or for different currency

If you would like a copy feel free to PM me or reply to this thread

Mark

 

[yarnoss]

Thank you black death for your interest in my topic.
I would like to see your spread sheet and formulas.I will email my finished spreadsheet once iam finished with it!!!
Can you please email your sheet ???