If Condition

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top