Multiply different columns depending on 3 specific criteria

[Letorc]

Hello,

I can get by with Excel, but I'm not great. I'm looking to multiply different columns depending on criteria.

See picture of what I'm working on. What I'm looking for is a formula that will multiply E3 by I3 if H3=1. F3 by I3 is H3=2, and G3 by I3 if H3=3.

I was able to get this working with a SUMIF for one condition, but am unsure how to do all 3 conditions in one formula.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(H3="","",I3*CHOOSE(H3,E3,F3,G3))

 

[Letorc]

Hey, thank you. That worked perfectly, thank you for the help!

 

[Fluff]

You're welcome & thanks for the feedback.