Formula to predetermine ebay list price

[djgaz]

Hi There,

I wanted to create a formula on my speadsheet that will automatically populate the selling price for an item on eBay.

Cell A = Cost Price (price I paid for the item)
Cell B = Ebay Selling fee (12.8% Plus 30p fixed fee)
Cell C = Profit margin on the cost price (15%)
Cell D - List Price
So basically I know what Cell A is going to be and after the fees are added on, I want 15% of Cell A as profit so is there a formula that will automatically populate Cell D?

Thanks in advance

 

[jtakw]

Hi,

I'm not familiar with eBay selling policy, please clarify what 30p means.

 

[SQUIDD]

so if cell a is £100
cell b is 13.10
cell c is 15
cell d will be 127.80?

if so in cell D
=(A2+B2)*1+C2

 

[jtakw]

Ok, lookup it up, 30p is 30 cents per order?

See if this works for you:

Book3.xlsx
	A	B	C	D
1	Cost	eBay fees	Profit %	List Price
2	100	13.1	15.00%	128.1
3	55	7.34	15.00%	70.59
4	45.75	6.156	15.00%	58.7685
Sheet996

Cell Formulas
Range	Formula
B2:B4	B2	=A2*0.128+0.3
D2:D4	D2	=A2*C2+A2+B2

 

[SQUIDD]

Hi,

I'm not familiar with eBay selling policy, please clarify what 30p means.

British currency

100 p in 1 GBP

 

[djgaz]

Hiya,

I have managed to solve it,

=ROUNDUP((ITEMCOST+15%OFITEMCOST+30PFIXEDFEE)/(1-12.8%),2)

30p means 30 pence (like cents) its the fixed fee ebay charge in the UK per order on top of the 12.8% of the final fee