Specifically how do you determine what percentage each element is worth of
the whole? If there are two elements do they automatically get 50% each or
can one be worth 25% the other 75%?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CelticCharmer" wrote:

Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a cell. What I want to do is as soon as I input the completed date I
want excel to work out the percentage as they complete the course e.g. 6%,
15%, 75%, etc until they are finished 100%.
The amount of elements the students do changes from student to student from
28 to 34. What formula I can use? Do I have to change the formula from
student to student to get 100%?
If you need any more information please ask.