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