Formula Help!

[Travisallen2007]

I am hoping that y'all can help! I am trying to get a formula that says,

If A21 says Nickles do =((B21+C21)-D21)*2
If A 21 Says Dimes do =((B21+C21)-D21)*5

The list will change and say Quarters and change the last multiplier to *10, Ones *20, Fives *40, Tens *40, Twenties*80, Pennies (DOLLARS)*1

I would like for the list in A21 to be changable and then automatically update the formual in E21.

Thanks for taking the time to read this and help if possible!

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G	H
20							Dimes	5
21	Nickles	5	2	4	6		Nickles	2
22							Quarters	10
23
3b

Cell Formulas
Range	Formula
E21	=LOOKUP(A21,G20:H22)*(B21+C21-D21)

 

[Travisallen2007]

Thank you! This will work perfect!

Thanks again for your reply and help, I really appreciate your time!

 

[mrshl9898]

=IF(A21="Nickles",2,IF(A21="Dimes",5,IF(A21="Dimes",5,IF(A21="Dimes",5,IF(A21="Dimes",5,IF(A21="Dimes",5,IF(A21="Dimes",5,IF(A21="Dimes",5,""))))))))*((B21+C21)-D21)

i've added nickles and dimes, you'll need to update the dimes and corresponding 5's to suit the rest

 

[Dave Patton]

=LOOKUP(A21,{"Dimes",5;"Nickles",2;"Quarters",10})*(B21+C21-D21)

or

=((A21="Dimes")*5+(A21="Nickles")*2+(A21="Quarters")*10)*(B21+C21-D21)

 

[Travisallen2007]

This is great! I got it all updated and g2g! Thanks a million!