Cell A2 = your Item Price
Cell B2 = the fee (=VLOOKUP(A1,$E$1:$F$8,2))
Cells E1 to F8 the fee chart
0Â Â Â Â Â Â Â 0
0.01Â Â Â Â 0.3
1Â Â Â Â Â Â Â 0.35
10Â Â Â Â Â Â 0.6
25Â Â Â Â Â Â 1.2
50Â Â Â Â Â Â 2.4
200Â Â Â Â Â 3.6
500Â Â Â Â Â 4.8
Hope that works out for you.
Edit: why that works....
(excel help file)
Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
Remarks
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value.