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