Calculate Ebay Insertion Fees

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