quite complicated functions(ebay fees)

thanks
but no not really
because i the fees vary depends on how much it sold for it needs to work out that so it it was £40 it would be 10 % of the first £4.99 and then 8% of the rest up until 9.99 and then 6% of the rest of the money up until the £40.

i dont have set fees.

any ideas?

If sale price is in A1 this should give you the fees

=A1*4%+(MIN(A1,50)+MIN(A1,10)+MIN(A1,5))*2%

I simplified the formula slightly. The one I started off with was this

=A1*4%+MIN(A1,50)*(6%-4%)+MIN(A1,10)*(8%-6%)+MIN(A1,5)*(10%-8%)

The trick is to break the formula down in a different way. Rather than looking at how much the % is for each band you can get the total by multiplying the whole amount by the top band % [A1*4%] then adding the top of the next band - or A1, whichever is lower [MIN(a1,50)] multiplied by the difference between the 2 bands [6%-4%]. you then do the same for the two remaining bands. In this case, because the difference in bands is always 2% you can simplify to

=A1*4%+(MIN(A1,50)+MIN(A1,10)+MIN(A1,5))*2%

Note: This formula keeps adding 4% no matter how high the amount goes. If this is supposed to become 0% above £500 then it can be adjusted to

=MIN(A1,500)*4%+(MIN(A1,50)+MIN(A1,10)+MIN(A1,5))*2%

You can also do the same thing with SUMPRODUCT. This formula will give the same result as the first formula I posted

=SUMPRODUCT(--(A1>{0,5,10,50}),A1-{0,5,10,50},{10,-2,-2,-2})/100

I will have to read this over a few times but i do sort of get it just like anything once the penny drops it will always be logical. cheers for the explanation and i hope macwillis is happy with the result.

I myself was happy to have figured my first question on here out but just as i went to post you had added a forumla 80% smaller than mine so it squashed mine a little but, its all a learning curve, thanks again.

yup thats great i think that will do. now i just need to work out hot to make it work out the insertion fee and other paypal fees.
£0.01 - £4.99 - 3p
£5.00 - £9.99 - 5p
£10.00 - £49.99 - 7p
£50.00 - £499.99 - 9p
£500 and over is 11p

seening as im selling buy not only items these are set figures.

if i write spread sheet with what i need in it could someone have a look for me?

im using excel for mac but that shouldn't have a difference.