Calculate Ebay Insertion Fees

[bbsdaddy]

Hi! I am trying to automate my excel spreadsheet that tracks ebay sales.
Does anyone have a formula that calculates ebays insertion fees? The fees
are as follows:
Start Price Insertion Fee
0.01-0.99 0.20
1.00-9.99 0.35
10.00-24.99 0.60
25.00-49.99 1.20
50-199.99 2.40
200.00-499.99 3.60
500 or more 4.80

I am a novice excel user and when I tried to set up the fees I (needless to
say) failed miserably.
Any help would be most appreciated.
Thanks

 

[Peo Sjoblom]

With your price in A1 you can use


=IF(A1="","",LOOKUP(A1,{0;1;10;25;50;200;500},{0.2;0.35;0.6;1.2;2.4;3.6;4.8}))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[bbsdaddy via OfficeKB.com]

Peo, thank you so much! What would this formula be classified as? I would
like to also look in the Excel help to try to understand the logic and the
conventions of a formula such as this.

Thank you again; I really appreciate it.

With your price in A1 you can use

=IF(A1="","",LOOKUP(A1,{0;1;10;25;50;200;500},{0.2;0.35;0.6;1.2;2.4;3.6;4.8}))

Hi! I am trying to automate my excel spreadsheet that tracks ebay sales.
Does anyone have a formula that calculates ebays insertion fees? The fees

[quoted text clipped - 13 lines]

Any help would be most appreciated.
Thanks