• ## RetiredGeek I need your help,,, immensely

Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » RetiredGeek I need your help,,, immensely

Author
Topic
#497779

Welcome to the Lounge as a new poster! :cheers:

Apologies for getting you’re attention this way i saw no other way to directly contact you 🙂

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 Import Price Total Sold Stock Left Price Sold Total Profit Ebay(10%) Paypal(2%)
Paid Tax Paid
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 ? ?

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