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

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" <u20226@uwe wrote in message news:5df2699661ef2@uwe...
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, 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.

Peo Sjoblom wrote:
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

--
BBsDaddy

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200603/1