Making a worksheet to help keep track of eBay auctions

[srburk]

Lets say I want a worksheet to automatically calculate my listing fees.

Starting Price, Opening Value or Reserve Price Insertion Fee
Between 0.01 and 0.99 $0.30
Between 1.00 and 9.99 $0.35
Between 10.00 and 24.99 $0.60
Between 25.00 and 49.99 $1.20
Between 50.00 and 199.99 $2.40
Between 200.00 and 499.99 $3.60
>500 $4.80

I was thinking of using a VLOOKUP but how do I use it for an existing range? For example, if I enter $8.00, how do I get it to refer back to the one row with the range in it? Or, must I have a row for each cent?

 

[plettieri]

Hi:


See here for two methods on a possible solution...

http://www.mrexcel.com/board2/viewtopic.php?t=46678&highlight=commissions+range


hope this helps

plettieri

 

[Barry Katcher]

If I'm reading your question correctly, look at the formulas in column B.

Book2
	A	B	C	D	E	F	G
1	Input	Return			Lookup	List
2	0.15	0.30			From	To	Amt.
3	0.99	0.30			0.01	0.99	0.30
4	1.00	0.35			1.00	9.99	0.35
5	9.99	0.35			10.00	24.99	0.60
6	10.00	0.60			25.00	49.99	1.20
7	24.99	0.60			50.00	199.99	2.40
8	25.00	1.20			200.00	499.99	3.60
9	49.99	1.20			500.00		4.80
10
11	50.00	2.40
12	199.99	2.40
13	200.00	3.60
14	499.99	3.60
15	500.00	4.80
16	1,000.00	4.80
Sheet2

 

[srburk]

If I'm reading your question correctly, look at the formulas in column B.

Thank you! You are awesome!