Which formula to use

[spritchett]

I am trying to use the following formulas in the same cell so depending on which C-cell value, it will do the calculations. Anyone have any idea on how to go about this?

=IF(C2:C38=5551,E2*1.3270)

=IF(C2:C38=8742,E2*1.1180)

=IF(C2:C38=5645,E2*1.3095)

=IF(C2:C38=8810,E2*1.1170)

=IF(C2:C38=5606,E2*1.1304)

[#2]

Hi

Build a lookup table and refer to it with VLOOKUP().

					5551	1,327
5645		4,5	5,89275		8742	1,18
					5645	1,3095
					8810	1,117
					5606	1,1304

=VLOOKUP(C2,$H$1:$I$5,2,FALSE)*$E$2