Dec 04 2018 09:35 AM
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)
Dec 04 2018 10:54 AM
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