Nested If Statement with Calculations

[PTori82]

I need to enter a formula in a cell that does the following:

If S2= ‘L’ then multiply V2 by W2, If S2=’R’ then multiply T2 by U2, If R2 =’S’ then multiply X2 by Y2.

Thank you very much to anyone that can help with this!

 

[AhoyNC]

Maybe:

[TABLE="width: 510"]
<colgroup><col width="510"></colgroup><tbody>[TR]
   [TD="width: 510"]=IF($S$2="L",$V$2*$W$2,IF($S$2="R",$T$2*$U$2,IF($R$2="S",$X$2*$Y$2)))[/TD]
 [/TR]
</tbody>[/TABLE]

What should the result be if S2="L" and R2="S"?

 

[PTori82]

The result is a calculation. If a batter is facing a left handed pitcher then S2 will read "L" and calculate the batter strike out percentage weighted for the pitcher's strike out rate versus the batters handedness. This formula works and I greatly appreciate it!