Conditional formula. Calculate based on value in another column

[RodneyC]

I have four different calculations I could use, which one to use is based on a value on another column.

I'm looking for a formula to put in column L.

Let's say all cells in column K have a value of either 1, 2, 3, or 4. If the value in K is 1, then the formula in L should look at the value in G and should multiple that value by the value in CalcF4 (*Calc!F4) If the value in K is 2 then CalcF4 will change to CalcF5, CalcF6 for 3 and CalcF7 for 4.

Thanks in advance.

 

[James006]

Hi,

With your reference cell as K2, you can test

=G2*OFFSET(Calc!$F$3,K2,0)

 

[Sufiyan97]

Try

=IF(K2=1,G2*Calc!F4,IF(K2=2,G2*Calc!F5,IF(K2=3,G2*Calc!F6,G2*Calc!F7)))

 

[Marcílio_Lobão]

RodneyC, Good morning.

The beauty of Excel is that you can get the same result in different ways.

=G2 * CHOOSE(K2, Calc!$F$4, Calc!$F$5, Calc!$F$6, Calc!$F$7)

Have a nice day!

 

[James006]

RodneyC, Good morning.

The beauty of Excel is that you can get the same result in different ways.

=G2 * CHOOSE(K2, Calc!$F$4, Calc!$F$5, Calc!$F$6, Calc!$F$7)

Have a nice day!

The Beauty of Excel ... AND the Beauty of Belo Horizonte ...

 

[RodneyC]

Brilliant. Yes, one of the many things I love about Excel is there is more than one way to skin this cat. Thank you all. I've got it working.

 

[Marcílio_Lobão]

RodneyC,

Thanks for the feedback.

I'm happy to have been able to help you along with the other colleagues here.

 

[Marcílio_Lobão]

The Beauty of Excel ... AND the Beauty of Belo Horizonte ...

James006, Good afternoon.

Indeed, we live in a beautiful and pleasant city.

All visitors are always very welcome here.

Have a great weekend.