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.
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.