Ebay Spreadsheet & non Ebay finances *tricky one for the experts maybe*

[Paulo11]

Hi

OK so I will try to make this simple. I am new and wouldn't have a clue where to look for this. I am a complete novice with little talent in Excel. Let me get to it.

I am trying to create a spreadsheet that allows me to input my data from sales from Ebay and outside of Ebay. Inside Ebay would include listing fees, 10% final value fees, Paypal fees and any extras. Outside of Ebay non of these fees would exist apart from the purchase price (buy to sell).

Now i have created a table with simple formulas. So when I change the quantity of stock the sales stock (showing what i have left) changes along with the profit cell and ebay fees and paypal fees cells.

My aim is to have a formula or something (i really have no clue) to where I can enter any price of the sales cell and have the option of adding the ebay and paypal fees. for example....

	Quantity	Price Paid	Import Tax	Price Paid	Total		Sold	Stock Left	Price Sold	Total		Profit	Ebay (10%)	Paypal (2%)
Quavers	5	£0.30	£0.05	£1.50	£1.75		4	1	£1.00	£4.00		£2.25	?	?
Skittles	5	£0.30	£0.05	£1.50	£1.75		1	4	£1.00	£1.00		-£0.75	?	?

<colgroup><col><col><col span="3"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

so this is the table i have (as shown above) and as i said previously i change the SOLD cell and the QUANTITY changes along with all the other cell. But My problem is when I make sales outside of Ebay these fees dont occur (ebay 10% & paypal 2%). Also some time my purchase price might change so this will change on import tax etc as well. So I need a table where I can have a drop down box or enter a value and have options of a changing values but still keep adding/showing the profit and costs.

I hope I have explained this clearly. I hope someone with vast knowledge can help !!! :/

Thanks for looking guys

 

[Paulo11]

Can Any one Help please.....