EBAY SPREADSHEET

yarnoss

Board Regular
Joined
Apr 7, 2003
Messages
94
:) Iam trying to write a SPREADSHEET to manage my ebay auctions i have 8 columns :eek:
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. :rolleyes:

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 ? :oops: This is the commission i pay ebay which is a percentage of the endprice of the auction

(y) ebay fees (y)
:-> $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 :eek:

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!!!!
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Txtaz6763

New Member
Joined
Mar 3, 2004
Messages
27
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

Well-known Member
Joined
Feb 20, 2004
Messages
636
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

Well-known Member
Joined
Jun 7, 2002
Messages
500
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 :biggrin:
 

yarnoss

Board Regular
Joined
Apr 7, 2003
Messages
94
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 ???
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,850
Members
414,342
Latest member
K Darrell Smith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top