On Apr 1, 8:02 pm, ArthurN wrote:
Hi, and thank you,
I guess, I wanted something a bit different. I think my original post was
too ambiguous.
This is the table that I have:
A B C D E F
1 16 15 17
2 Psych 188 120 4 6 2
Whe
B:B lists the total num of class work hours
C:C lists the total num of extra curricular hours
D1 lists in line 1 the num of weeks per 1st term
E1 - the num of weeks per 2nd term
F1- the num of weeks per 3rd term
Then the table holds all the subjects, e.g.
I know that psychology has 4 hours (2 classes) x 16 weeks in the 1st term,
which is 64 hours/32 classes. The sum of all the hours in 3 terms = 188 (B2).
Now, the num of extra curricular hours (C2) should be distributed
proportionally between all the terms, and the num should be dividable by 2
(each class has 2 hours). The trouble is that making the num dividable by 2,
while it might break the proportion a bit, is more important.
Thanks,
Arthur N

=ROUND(($C$3/2)*percent,0)*2
Where "percent" needs to be calculated on each term to get your split.
And C3 is the extracurricular hours. For 3 terms, you need 3 of these
formulas. Should work if only even numbers are entered for
extracurricular.