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

[TABLE="width: 1200"]
<colgroup><col><col><col span="3"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Quantity
[/TD]
[TD]Price Paid[/TD]
[TD]Import Tax[/TD]
[TD]Price Paid
[/TD]
[TD]Total
[/TD]
[TD] [/TD]
[TD]Sold[/TD]
[TD]Stock Left[/TD]
[TD]Price Sold
[/TD]
[TD]Total
[/TD]
[TD] [/TD]
[TD] Profit
[/TD]
[TD] Ebay (10%)
[/TD]
[TD] Paypal (2%)
[/TD]
[/TR]
[TR]
[TD]Quavers
[/TD]
[TD]5
[/TD]
[TD]£0.30
[/TD]
[TD] £0.05
[/TD]
[TD] £1.50
[/TD]
[TD]£1.75
[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]1
[/TD]
[TD] £1.00
[/TD]
[TD] £4.00
[/TD]
[TD] [/TD]
[TD]£2.25
[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[/TR]
[TR]
[TD]Skittles
[/TD]
[TD]5
[/TD]
[TD]£0.30
[/TD]
[TD] £0.05
[/TD]
[TD] £1.50
[/TD]
[TD]£1.75
[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]4
[/TD]
[TD] £1.00
[/TD]
[TD] £1.00
[/TD]
[TD]
[/TD]
[TD]-£0.75
[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[/TR]
</tbody>[/TABLE]


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