Multiply a cell by one of three others, based on first cell's value

[MADIME39]

Hi there, I have never been good at Excel formulas, so grateful for this site. I am looking to multiply a cell by one of three others, based on the value in the first cell. If I enter the number 1 in E28, I want to multiply E28 by cell F28, with the results in I28. If E28 has a number 2 I want to multiply it by G28. If E28 has a number 3 I want to multiply it by H28. Thanks so much in advance!

 

[jmacleary]

Hi there. Put this formula into I28:

Book1
	I
28	15
Sheet1

Cell Formulas
Range	Formula
I28	I28	=E28*--INDEX(F28:H28,1,E28)

The double minus is to stop a#value error occurring if any of F,G or H are empty

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(E28<>"",E28*CHOOSE(E28,F28,G28,H28),"")

 

[MADIME39]

Both worked, thank you so much! I wish the formulas weren't so confusing lol. Thank you again!

 

[Fluff]

Glad we could help & thanks for the feedback