A formula please...

  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
and add them togther.

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.

Thanks in advance

  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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…