N
nhims786
I have got the following table in a Excel worksheet:
A B C D E
1 Name Grade Fee1 Fee2 Fee3
2 James I 1000 1500 2000
3 Peter II 1500 2000 2500
4 Kate III 2000 2500 3000
5 Mary IV 2500 3000 3500
Actually the data in the cells C2-C5, D2-D5 & E2-E5 don't exist. What I want is when I enter 'I' in the cell B2, using IF (or any other) condition, the cells in C2, D2 & E2 should automatically be filled with 1000, 1500 & 2000 respectively. Same is the case with the data in the cell B3 i.e. when I enter 'II' in the cell B3, using IF (or any other) condition, the cells in C3, D3 & E3 should automatically be filled with 1500, 2000 & 2500 respectively.
Is this possible in MS-Excel 2007?
Thanks
A B C D E
1 Name Grade Fee1 Fee2 Fee3
2 James I 1000 1500 2000
3 Peter II 1500 2000 2500
4 Kate III 2000 2500 3000
5 Mary IV 2500 3000 3500
Actually the data in the cells C2-C5, D2-D5 & E2-E5 don't exist. What I want is when I enter 'I' in the cell B2, using IF (or any other) condition, the cells in C2, D2 & E2 should automatically be filled with 1000, 1500 & 2000 respectively. Same is the case with the data in the cell B3 i.e. when I enter 'II' in the cell B3, using IF (or any other) condition, the cells in C3, D3 & E3 should automatically be filled with 1500, 2000 & 2500 respectively.
Is this possible in MS-Excel 2007?
Thanks