Hi,
I have a sheet that requires multiple nested IF statements in calculations and was thinking of using CHOICE to drive selection of formula. Here is an example of what I'd like to do. A1:B10 contain values, in C1:C10 I'd like to put a =Choice() formula that refers to formulas that are written out in e1:e3 (Ex: e1: A1+B1, e2: A1-B1, e3: A1*B1). I'd like to add a column D1:D10, with 1,2 or 3 to drive the choice of formula. Is there a way that I only need to write out the formula once in those 3 cells e1:e3, and apply my choice to the result cell in C without using VBA?
Thx.
I have a sheet that requires multiple nested IF statements in calculations and was thinking of using CHOICE to drive selection of formula. Here is an example of what I'd like to do. A1:B10 contain values, in C1:C10 I'd like to put a =Choice() formula that refers to formulas that are written out in e1:e3 (Ex: e1: A1+B1, e2: A1-B1, e3: A1*B1). I'd like to add a column D1:D10, with 1,2 or 3 to drive the choice of formula. Is there a way that I only need to write out the formula once in those 3 cells e1:e3, and apply my choice to the result cell in C without using VBA?
Thx.