Anyone know... Combo Boxes in Excel 2003?
#14


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.
Reply


Messages In This Thread
Anyone know... Combo Boxes in Excel 2003? - by Nvts - 04-27-2004, 08:54 PM

Forum Jump:


Users browsing this thread: 7 Guest(s)