Hi folks
I am wondering if there is a pricing formula that can calculate a selling price, based on a few things:(without making a circular reference) that sets a profit value of a certain amount rather than a percentage)
- Supplier's Cost
- eBay & PayPal Deductions (13.4% of selling price + £0.20)
Example
Cost Sell Deds Profit £7.00 £9.47 £1.47 £1.00
In the example, I've put in the correct figures, the third cell (B3) is 13.4% of (B2) + £0.20,
Cell (B4) is a simple calculation of (=B2-B1-B3)
Is there a formula that I can put in (B2) so that it will always display £1.00 in cell (B4), regardless of the value of cell (B1)
I've tried a few ideas & never got the correct outcome, does anyone have an idea
Thanks!
Bookmarks