Numbers app help

[Oktober]

I am selling some items (on going) for a friend and I would like to easily see what what the end cost is etc...

I am new to Numbers so not sure if what I have started is correct at all?

I have working out that

Ebay items charges are 10%
Ebay postage charges is 10%
and PayPal take a further 5%
I can work the maths out manually, but how does one input that into a spreadsheet correctly?

So how do I set up a formula for deduct 5% or 10% from a price. At the moment is taking away 5p or 10p respectively.

The formula I am using is

=c2-d2

or £8.04-10%

I have attached a screen shot for your to tell me where I have gone wrong (probably everywhere), but if someone advise me I would be appreciative of it.

Darren

 

[GoodHealthIT]

I suspect you've made it a bit more complicated than it should be. Perhaps try and lay it out like this:

Column A: Item Price
Column B: Shipping Price
Column C: Total Purchase Price (=SUM(ColA,ColB))
Column D: Ebay Fee (=ColA*.1)
Column E: Ebay Postage (=ColB*.1)
Column F: PayPal Fee (=ColC*.05) - assuming PayPal fee is percentage of total purchase price
Column G: Total Fees (=SUM(ColD,ColE,ColF))
Column H: Net Sale (=ColC-ColG)