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 ?
:-> $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!!!!