Formula to predetermine ebay list price

djgaz

New Member
Joined
Feb 13, 2022
Messages
2
Office Version
  1. 2007
Platform
  1. Windows
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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
7,245
Office Version
  1. 2016
Platform
  1. Windows
Hi,

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

SQUIDD

Well-known Member
Joined
Jan 2, 2009
Messages
2,038
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Jun 29, 2014
Messages
7,245
Office Version
  1. 2016
Platform
  1. Windows
Ok, lookup it up, 30p is 30 cents per order?

See if this works for you:

Book3.xlsx
ABCD
1CosteBay feesProfit %List Price
210013.115.00%128.1
3557.3415.00%70.59
445.756.15615.00%58.7685
Sheet996
Cell Formulas
RangeFormula
B2:B4B2=A2*0.128+0.3
D2:D4D2=A2*C2+A2+B2
 
Last edited:

djgaz

New Member
Joined
Feb 13, 2022
Messages
2
Office Version
  1. 2007
Platform
  1. Windows
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
 

Forum statistics

Threads
1,175,859
Messages
5,899,909
Members
434,805
Latest member
Nihon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top