Combine IF Statement with multi-multiplication

[abeck1095]

Hi,

I am trying to find a formula which will help me do:

If G17 = 1 then multiply Cell F17 by cell D13
If G17 = 2 then multiply Cell F17 by cell E13
If G17 = 3 then multiply Cell F17 by cell F13
If G17 = 4 then multiply Cell F17 by cell G13
If G17 = 5 then multiply Cell F17 by cell H13

My current formula is:

=IF(G17="1",F17*$D$13,IF(G17="2",F17*$E$13,IF(G17="3",F17*$F$13,IF(G17="4",F17*$G$13,IF(G17="5",F17*$H$13)))))

However, I get a "FALSE" response when I try this... I can't figure out how to override the FALSE part of the IF statement?

Sorry if that makes no sense! I can provide a screenshot if needs be.

Thanks

 

[abeck1095]

Also, I forgot to mention that I will be dragging this formula down approx. 100 lines. The constant conditions being Cells D13, E13, F13, G13, H13.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IFERROR(F17*CHOOSE(G17,$D$13,$E$13,$F$13,$G$13,$H$13),"")

 

[abeck1095]

Hi & welcome to MrExcel.
How about

=IFERROR(F17*CHOOSE(G17,$D$13,$E$13,$F$13,$G$13,$H$13),"")

Hi,

Sorry I accidentally sent the reply too early.
Thanks for the quick response, I don't think I explained this very well!
I have attached a screenshot.

So the calculation depends on the space type
Space type 1 = Blue
Space type 2 = Orange
Space type 3 = Grey
Space type 4 = Yellow
Space type 5 = Green

Dependent on the space type, I want to take the value from the corresponding Cell (D13,E13,F13 etc.)
Thanks

 

[Fluff]

Did you try my suggestion?

 

[abeck1095]

Did you try my suggestion?

Sorry - Yes. This seems to have worked now! Thanks a lot.

 

[Fluff]

You're welcome & thanks for the feedback.