jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 378
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
Libro1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | 2 | 7 | 4 | 8.9 | 2.5 | 500 | 1 | 1000 | |||
Hoja1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I1 | I1 | =A1*G1 |
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?
thanks