yarnoss

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

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Brian from Maui

MrExcel MVP
Try this,
Book1
ABCD
1EndEnd+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

New Member
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
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
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

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

Replies
2
Views
420
Replies
4
Views
225
Replies
7
Views
735
Replies
13
Views
16K
Replies
21
Views
2K

1,181,896
Messages
5,932,676
Members
436,850
Latest member
Jasperlee93

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.

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

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