A formula please...

  Major Disaster 20:40 24 Sep 2005
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 2005

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 2005

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.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017