Need urgent help using if then else in excel 2007

I am creating an excel worksheet. I've created a user form to select multiple entries and display the selected entries in column F.
Now, I need to do some calculation in column J which is quiet similar to column L. The only difference is, in column L, I'm doing the
calculation for the total remaining effort and in column J, I need to calculate it for the selected entries in column F.

Now, could you please help me writing a similar formula to calculate individual remaining effort and display the same in column J?

Lets say I've selected the entries abc & xyz in column F. Now in column I&J, depending on the calculation, the results should be displayed
as -
column I: abc: 50% ,xyz: 50%
column J: abc:50% ,xyz: 50%

Similarly, if I select abc, xyz and lmn in column F, then after the calculation the results should be displayed as -

column I: abc: 33%, xyz: 33%, lmn: 33%.
column J: abc: 33%, xyz: 33%, lmn: 33%.

Again, if I select just in column F, then after the calculation the results should be displayed as

Column I: abc: 50%
Column J: abc:50%

Please note the values 33%, 50% etc. mentioned above are just dummy values I've used in this question.

However, I want it to be displayed based on the values selected in Column F & the calculation in I.


Please refer my previous post more details.

http://www.excelforum.com/excel-prog...el-2007-a.html

I want to implement the same thing to calculate individual effort required & remaining individual effort and also display the same in the cell as stated above.

I've also attached the excel sheet for reference.