Major Disaster 20:40 24 Sep 05
Locked

I am making a spread sheet of all my ebay transcations.

I want to be able to figure out what the fees of an item will be, automatically.

Say i put on a DVD for £4.00 and it sold for £5.00 i would then have to look at the price brackets for the insertion and final value fees click here

Is there some formula (maybe an IF formula?) that will see that in C5 (say) the origonal value (is say £4.00) and be able to say that that means .20p insertion fee? Sams for final value.

VoG II 20:59 24 Sep 05

For the Insertion prices the easiest thing is to use a lookup table click here

For the othger with a value in A1

=IF(A1>=600,1.57+18.53+1.75%*(A1-599.99),IF(A1>=30,1.57+3.25%*(A1-30),IF(A1>=0.01,5.25%*A1,0)))

Major Disaster 21:01 24 Sep 05

Thanks a lot VoG, you obviously spent some time on that and it is much appreciated.

Thanks again

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now