help im new to excel

[topaz494]

im trying to make up a spread sheet in excel to help me work out my ebay stuff and need help with the formula this is what i want to do

1 price i sold article for
2 above price - ebays fees(5.25% up to£30 then 3.25% after + a listing fee which varies)
3 above figure -3.4% then add 20p
4 - from above figure p&P which varies
5 total to end up with

if anybody replies i will be amazed thamks john

 

[Andrew Poulsom]

Welcome to the Board.

Your problem can't be solved unless you know how the listing fee and P&P vary. Tell us that and someone will give you the formulas.

 

[topaz494]

thanks for replying im trying to learn this as a silver surfer so try to bear with me cant i just fill this cell in every time with a new figure then this would be minused from the previous cell john

 

[Andrew Poulsom]

Maybe:

BOOK8
	A	B	C	D
1	Price	100.00
2	Fees	-8.53
3	Other	-3.60
4	P&P	-1.00
5	Net	86.87
Sheet1

Formulas (list fee and P&P assumed at 1):

B2 =-ROUND((MAX(30,B1)*5.25%)+((B1>30)*((B1-30)*3.25%)+1),2)
B3 =-ROUND((B1*3.4%)+0.2,2)
B5 =SUM(B1:B4)

 

[Seti]

You can shorten Andrews formula in B2 somewhat with the following if you like:

B2 = -ROUND((MAX(B1-30,0)*2%+B1*3.25%),2)

Also, I think Andrew needed MIN not MAX at the start of his formula.

 

[topaz494]

thanks what a star this man thats saved me loads of time and finger nails john

 

[topaz494]

with the revision andrews formule works fine but assuming the list fee and P&P assumed to be 1 is giving me a problem i need to be able to alter this between 42p and 92p any help to finish this would be great

 

[Mark F]

Ebay Fees

John

I have been playing around with an Ebay Fee / Net Sale Value Calculator.

It is not fully tested but you are welcome to have a look.

Let me know if you would like it

Mark