Using IF function several times referencing a Dropdown to calculate a 'minimum' charge

Hello, New to Excel Forum but have used it as a reference many times.

I'm trying to create three different cells (Debit, Visa and MasterCard) that calculate a minimum charge based on a minimum 'threshold'. However, the minimum can be applied to Debit, Visa and MasterCard individually, Debit and Credit separately, or all three combined. I have a drop down box referencing four cells: 'Select One' (what I'll leave as the default), 'Debit/Visa/MasterCard', 'Debit/Credit', 'Combined'. elsewhere on the spreadsheet I have formulas that calculate individual charges for rates on Debit, Visa and MasterCard.

So this is what I want the cells to do in English:
IF dropdown is 'Select One' then return a blank value, but IF dropdown is 'Debit/Visa/MasterCard' then Debit cell returns the difference between the minimum threshold and the Debit charge while Visa and MasterCard cells do the same with their respective thresholds and charges, but IF dropdown is 'Debit/Credit' then Debit cell returns the difference between the minimum threshold and the Debit charge while Visa (which would rename itself to 'Credit') returns the difference between the minimum threshold and the Visa and MasterCard charges, IF dropdown is 'Combined' then Debit (which would rename itself to 'All Minimums') returns the difference between the minimum threshold and the Debit, Visa and MasterCard charges.

I've tried so many different ways but I can't get it working! Please Help!

Originally Posted by FDibbins

bpierder, welcome to the forum

add an extra category to your table (with the calcs for "debit/visa/master" etc) for "select One" and leave it blank.

then use a vlookup based on your drop-down to find the relevant value from your table

let me know how you make out?

I'm not sure what you mean. I've used VLOOKUP before but I'm not sure how I would apply it here. I'm going to play around with this and see if I can make it work but can you expand on this?

Sweet I got it! I made this array table:

	A	B	C	D	E	F	G	H	I	J
1	Select One	-	-	-	0	0	0	0	0	0
2	Debit/Visa/MasterCard	Debit	Visa	MasterCard	Debit Treshold	Debit Charge	Visa Treshold	Visa Charge	MasterCard Treshold	MasterCard Charge
3	Debit/Credit	Debit	Credit	-	Debit Treshold	Debit Charge	Credit Treshold	Credit Charge	0	0
4	Combined	Combined	-	-	-	Combined Treshold	Combined Charge	0	0	0

and referenced it in three cells this way:
=VLOOKUP(A5,A1:J4,2,) has a Minimum Charge of =IF(VLOOKUP(A5,A1:J4,5,)>VLOOKUP(A5,A1:J4,6,),VLOOKUP(A5,A1:J4,5,)-VLOOKUP(A5,A1:J4,6,),0)
=VLOOKUP(A5,A1:J4,3,) has a Minimum Charge of =IF(VLOOKUP(A5,A1:J4,7,)>VLOOKUP(A5,A1:J4,8,),VLOOKUP(A5,A1:J4,7,)-VLOOKUP(A5,A1:J4,8,),0)
=VLOOKUP(A5,A1:J4,4,) has a Minimum Charge of =IF(VLOOKUP(A5,A1:J4,9,)>VLOOKUP(A5,A1:J4,10,),VLOOKUP(A5,A1:J4,9,)-VLOOKUP(A5,A1:J4,10,),0)

And that worked like a charm! Thanks FDibbins!!