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

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?