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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch