- Feb 14, 2006
- Office Version
i have in: I1 a formula: c in Cell H1 i have a value of 1
here is the goal:
if in H1 is 3: the formula in I1 would be changed automatically to: =C1*G1
if in H1 is 5: the formula in I1 would be changed automatically to: =E1*G1
how to do?