mattfowkes
New Member
- Joined
- May 4, 2017
- Messages
- 1
Hi All - First time post and it's a bit of a doozy!
In the linked image, I'm creating a spreadsheet to help me cost up items for an eBay store. I've given 5 examples (including the formula from each cell of row 4) of how the COG (Cost of Goods), Stationary cost, Postage cost, eBay & PayPal fees are currently being used to calculate the percentage margin of each product.
However, I'd like to add a 'Low Price' column, as highlighted in red. This column will display the absolute low price that I'm willing to sell for, which is 10% margin dead (as displayed by Plant Pot A). I need this to change whenever I adjust either the COG, Stat. or Postage columns BUT (and this is the kicker) I don't want it to be effected by the 'Price' column. The 'Price' column will be used to display the current on-site price which ideally will always be higher than the low price and this will effect both the 'Fee' & 'PayPal' columns.
So effectively, the formula used in B4 to display the low price for Plant Pot A needs to predict what the low price will be including fees from eBay & PayPal without using those cells to find the answer... It's been running my brain in circles for hours.
Any help would be seriously appreciated. Cheers.
Image link below:
Imgur: The most awesome images on the Internet
In the linked image, I'm creating a spreadsheet to help me cost up items for an eBay store. I've given 5 examples (including the formula from each cell of row 4) of how the COG (Cost of Goods), Stationary cost, Postage cost, eBay & PayPal fees are currently being used to calculate the percentage margin of each product.
However, I'd like to add a 'Low Price' column, as highlighted in red. This column will display the absolute low price that I'm willing to sell for, which is 10% margin dead (as displayed by Plant Pot A). I need this to change whenever I adjust either the COG, Stat. or Postage columns BUT (and this is the kicker) I don't want it to be effected by the 'Price' column. The 'Price' column will be used to display the current on-site price which ideally will always be higher than the low price and this will effect both the 'Fee' & 'PayPal' columns.
So effectively, the formula used in B4 to display the low price for Plant Pot A needs to predict what the low price will be including fees from eBay & PayPal without using those cells to find the answer... It's been running my brain in circles for hours.
Any help would be seriously appreciated. Cheers.
Image link below:
Imgur: The most awesome images on the Internet